eval function

[shreyasamin64]

need help on eval function of trimming the month 

EX : April = APR 

all months first 3 letters 

thanks 

[Gr0und_Z3r0 · Accepted solution]

| makeresults 
| eval months="January February March April May June July August September October November December" 
| makemv delim=" " months
| mvexpand months
| eval short-month=upper(substr(months,1,3))
| fields - _time

Gr0und_Z3r0_0-1638346164590.png

[ITWhisperer]

| eval month=substr(month,1,3)