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!

Unleash the Power of Splunk MCP and AI, Meet Us at .Conf 2025, and Find Even More New ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Observability Professionals: Build Resilience and Visibility with These .conf25 ...

  If you're focused on performance, availability, and full-stack visibility, the Observability track at ...

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...