Splunk Enterprise

Field formatting

arunsoni
Explorer

Hi All,

I have a field which has improper format. I want to convert into a new field with proper format.

field name: Create

Value :  20190802212241Z

 

What I am looking is as below

New Field name : NewField

Value : 2019/08/02 21:22:41 

Thanks in advance!

Labels (1)
0 Karma

to4kawa
Ultra Champion

|eval NewField=strptime(Create,"%Y%m%d%H%M%S") |fieldformat NewField=strftime(NewField,"%Y/%m/%d %T")

0 Karma

isoutamo
SplunkTrust
SplunkTrust
If you want to keep timezone information with date and time then you must add also %Z to the end of formats.
R. Ismo
0 Karma
Get Updates on the Splunk Community!

.conf25 Community Recap

Hello Splunkers, And just like that, .conf25 is in the books! What an incredible few days — full of learning, ...

Splunk App Developers | .conf25 Recap & What’s Next

If you stopped by the Builder Bar at .conf25 this year, thank you! The retro tech beer garden vibes were ...

Congratulations to the 2025-2026 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...