Knowledge Management

extract date from filename in Splunk with customized datetime.xml?

azaki
Explorer

hey All
i want to extract date from filename the file name is as following :
filename xxx9935_20190223.txt
datetime.xml is as following:

<datetime>
<define name="mynewdate" extract="year, month, day">
     <text><![CDATA[(?:^|source::).*?(?<!\d|\d\.|-)(?:20)?([901]\d)(0\d|1[012])([012]\d|3[01])(?!\d|-| {2,})]]></text>
</define>
<timePatterns>
     <use name="mynewdate"/>
</timePatterns>
<datePatterns>
     <use name="mynewdate"/>
</datePatterns>
</datetime>

and i edited the props.conf to be look like this

DATETIME_CONFIG = /etc/apps/mashreq_atm/default/datetime.xml

could any one check why this isn't working?

1 Solution

azaki
Explorer
0 Karma

azaki
Explorer

the problem is solved by following the steps in here recommended from the support:
https://www.splunk.com/blog/2009/12/02/configure-splunk-to-pull-a-date-out-of-a-non-standard-filenam...

0 Karma
Get Updates on the Splunk Community!

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...

Introducing the 2024 Splunk MVPs!

We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...