topic Remove Timezone information from datetime field using spath while reading data from json file in Splunk Dev

Remove Timezone information from datetime field using spath while reading data from json file

Skhunte — Wed, 04 Nov 2020 14:35:44 GMT

Hi team,

I am extracting JSON data using spath. There is done datetime field and which is coming with zone name as below.

I want it without UTC word. like 2020-11-03 10:10:10

Can we do this using spath.

if yes please provide me example.

thank you for your help.

Sanket K

isoutamo — Wed, 04 Nov 2020 14:53:41 GMT

Can you post your original json?

Skhunte — Wed, 04 Nov 2020 16:36:10 GMT

Thank you for your comment.

to be honest i don't have JSON now because I am getting CSV as source which has JSON as source.

I have to suggest solution to trim zone factor.

If you can take any JSON file for sample which has time with zone as mentioned in my original post that will help me.

Thank you agian.

Sanket