Getting Data In

custom timestamp parsing

nikmeiser
Explorer

I have structured (CSV) files with named fields with a few different date-time formats -

TIMEA,host,TIMET,DURATION,HOUR,SHIFT
01/30/2012   0:00:00,host01,1327899600,3600,0,2

TIMET (third comma-separaetd value from left) is the UNIX time. How can I force Splunk to use that as timestamp for the event?

Tags (2)
0 Karma
1 Solution

nikmeiser
Explorer

Figured it out

TIME_FORMAT = %+ 
TIME_PREFIX = ^([^,]*,){2} 

View solution in original post

nikmeiser
Explorer

Figured it out

TIME_FORMAT = %+ 
TIME_PREFIX = ^([^,]*,){2} 
Get Updates on the Splunk Community!

The OpenTelemetry Certified Associate (OTCA) Exam

What’s this OTCA exam? The Linux Foundation offers the OpenTelemetry Certified Associate (OTCA) credential to ...

From Manual to Agentic: Level Up Your SOC at Cisco Live

Welcome to the Era of the Agentic SOC   Are you tired of being a manual alert responder? The security ...

Splunk Classroom Chronicles: Training Tales and Testimonials (Episode 4)

Welcome back to Splunk Classroom Chronicles, our ongoing series where we shine a light on what really happens ...