Splunk Search

_time from filename using Eval

SplunkBaby
Explorer

Hi

My file name is like ABC20140321.csv
I want splunk to read _time value from this file name.
I tried to edit datetime.xml and props.config and it doesn't work out for me.
How can I achieve this using EVAL in props.config

Thanks

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Have you read http://blogs.splunk.com/2009/12/02/configure-splunk-to-pull-a-date-out-of-a-non-standard-filename/?

---
If this reply helps you, Karma would be appreciated.
0 Karma

richgalloway
SplunkTrust
SplunkTrust

Is your datetime.xml file really in $SPLUNK_HOME/etc or $SPLUNK_HOME/etc/system/local?
Perhaps some escape characters got dropped from your comment, but your regex doesn't look right. This works in RegExr:

\ABC(\d{4})(\d{2})(\d{2})\.csv
---
If this reply helps you, Karma would be appreciated.
0 Karma

SplunkBaby
Explorer


<![CDATA[source::.?\ABC\d{4}\d{2}\d{2}..csv]]>



[host::DateFormat2]
DATETIME_CONFIG =/etc/datetime.xml
SHOULD_LINEMERGE = FALSE

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Please post your datetime.xml file and the relevant stanza from your props.conf file.

---
If this reply helps you, Karma would be appreciated.
0 Karma

SplunkBaby
Explorer

Yes ,unfortunately its not working for me.

0 Karma
Get Updates on the Splunk Community!

Data Management Digest – December 2025

Welcome to the December edition of Data Management Digest! As we continue our journey of data innovation, the ...

Index This | What is broken 80% of the time by February?

December 2025 Edition   Hayyy Splunk Education Enthusiasts and the Eternally Curious!    We’re back with this ...

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...