Splunk Enterprise

eval function

shreyasamin64
Explorer

need help on eval function of trimming the month 

EX : April = APR 

all months first 3 letters 

thanks 

 

Labels (1)
0 Karma
1 Solution

Gr0und_Z3r0
Contributor
| 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

 

View solution in original post

0 Karma

Gr0und_Z3r0
Contributor
| 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

 

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| eval month=substr(month,1,3)
Get Updates on the Splunk Community!

Index This | I’m short for "configuration file.” What am I?

May 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with a Special ...

New Articles from Academic Learning Partners, Help Expand Lantern’s Use Case Library, ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Your Guide to SPL2 at .conf24!

So, you’re headed to .conf24? You’re in for a good time. Las Vegas weather is just *chef’s kiss* beautiful in ...