Splunk Search

How to remove the timezone from my field in a CSV file?

PRIYANKA_1993
New Member

I'm fetching the data from a CSV file, but the issue with my data is that some of the values are in PDT and some are in PST.

The format is 2016-06-15 04:55 PM PDT. I just want all these values to be of same zone minus the time zone at the end. I want to display my data over a timechart.

0 Karma
1 Solution

sundareshr
Legend

Try this

| inputlookup xxx.csv | eval time=strptime(your_time_field,"%Y-%m-%d %H:%M %p %Z") | bin span=15m time | stats count by time | eval time=strftime(time, "%c")

View solution in original post

0 Karma

sundareshr
Legend

Try this

| inputlookup xxx.csv | eval time=strptime(your_time_field,"%Y-%m-%d %H:%M %p %Z") | bin span=15m time | stats count by time | eval time=strftime(time, "%c")
0 Karma

chanmi2
Path Finder

Hope this can help:

|inputlookup xxx.csv | eval _time=strptime(your_time_field,"%Y-%m-%d %H:%M %p %Z") | timechart span=5m count

the display time zone will be the user time zone, same as server time zone by default
the time format could be found in
http://docs.splunk.com/Documentation/Splunk/6.3.0/SearchReference/Commontimeformatvariables

0 Karma

PRIYANKA_1993
New Member

For some strange reason it is not showing any results.

0 Karma

chanmi2
Path Finder

could you remove |timechart span=5m count, and check if the _time is parsed correctly?

0 Karma

PRIYANKA_1993
New Member

After I changed the name of my time field, _time is getting parsed.

0 Karma

somesoni2
Revered Legend

Could you post your current search? Is the data from CSV being ingested to Splunk OR being used as lookup table OR direct csv access (inputcsv)?

0 Karma

PRIYANKA_1993
New Member

I am using inputlookup

0 Karma
Get Updates on the Splunk Community!

Introducing Splunk Enterprise 9.2

WATCH HERE! Watch this Tech Talk to learn about the latest features and enhancements shipped in the new Splunk ...

Adoption of RUM and APM at Splunk

    Unleash the power of Splunk Observability   Watch Now In this can't miss Tech Talk! The Splunk Growth ...

Routing logs with Splunk OTel Collector for Kubernetes

The Splunk Distribution of the OpenTelemetry (OTel) Collector is a product that provides a way to ingest ...