Getting Data In

Getting date and time from CSV

psow_splunk
Splunk Employee
Splunk Employee

Hi,

This is on Splunk 5 and I have a csv file sample header as foo,foo2,foo3,foo4,foo5,foo6
The date is on foo3 as 17/5/13 and the time is on foo5 as 815

I have the below in my props

[stype]

INDEXED_EXTRACTIONS = CSV

TIMESTAMP_FIELDS = foo3,foo5

TIME_FORMAT=%d-%m-%y %H%M

SHOULD_LINEMERGE = False

pulldown_type = 1

HEADER_FIELD_LINE_NUMBER = 1

REPORT-stype = stype_extract

and transform

[stype_extract]

DELIMS=","

FIELDS = "foo1", "foo2", "foo3", "foo4", "foo5",

Please kindly advise where i am missing. Thanks

Tags (2)
0 Karma

gkanapathy
Splunk Employee
Splunk Employee

Well, your date format specifies "-", but the data you say uses "/".

Also, indexed extractions only work on Splunk 6.0 and higher, not 5.

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Accelerate Splunk App Development with AI

  Learn how to automate the repetitive parts of your build cycle.   Watch On-Demand   Replay the Accelerate ...

Splunk Agent Observability: Measuring AI Value with Splunk Tokenomics on AWS

The AI landscape is moving faster than ever, and our latest 2026 State of Observability report provides the ...

Enterprise Security Watch Party: What’s New in 8.8 - Recap

Splunk Community HQ hosted a Splunk Enterprise Security Watch Party: What’s New In ES 8.8 last Thursday. I had ...