Getting Data In

Extract a non-strp timstamp across multiple pipe delimiters

jadamsplunk
Path Finder

Hi everyone,

Given an event like the following, is there a way to get this to successfully parse as _time at index time? I've tried including the pipe in my STRPTIME format but it does not work.

xxxx|yyyy|xxxx|yyyy|xxxx|yyyy|123000|111218|xxxx|yyyy

I would think that the following would work, but it has not:

TIME_FORMAT = %H%M%S|%m%d%y

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

Make sure you have sensible values for TIME_PREFIX and MAX_TIMESTAMP_LOOKAHEAD.

0 Karma

FrankVl
Ultra Champion

^^what he says. Especially if some of those xxx, yyyy may also contain 6 digit numbers...

0 Karma
Get Updates on the Splunk Community!

Your Guide to Splunk Digital Experience Monitoring

A flawless digital experience isn't just an advantage, it's key to customer loyalty and business success. But ...

Data Management Digest – November 2025

  Welcome to the inaugural edition of Data Management Digest! As your trusted partner in data innovation, the ...

Upcoming Webinar: Unmasking Insider Threats with Slunk Enterprise Security’s UEBA

Join us on Wed, Dec 10. at 10AM PST / 1PM EST for a live webinar and demo with Splunk experts! Discover how ...