Getting Data In

How do I deal w. single digit months/days in vix.input.1.et.regex?

jimjh
Path Finder

I have directory paths that look like

/year=2014/month=6/day=4/hour=1/

However, using the following regex is suboptimal, because yyyyMdH can cause ambiguity:

vix.input.1.et.regex = /year=(\d+)/month=(\d+)/day=(\d+)/hour=(\d+)/
vix.input.1.et.format = yyyyMdH

For example, given /year=2014/month=7/day=15/hour=9, Hunk will extract the digits, concatenate them into a string, and try to parse it as such:

scala> new SimpleDateFormat("yyyyMdH").parse("20147159")
res0: java.util.Date = Thu Jul 03 11:00:00 PDT 2014

which is incorrect. What regex should I use in this case?

Tags (2)
0 Karma
1 Solution

jimjh
Path Finder

Moving the = symbol into the capturing groups allows you to remove any ambiguity.

 vix.input.1.et.regex = /year(=\d+)/month(=\d+)/day(=\d+)/hour(=\d+)/
 vix.input.1.et.format = =yyyy=M=d=H

View solution in original post

jimjh
Path Finder

Moving the = symbol into the capturing groups allows you to remove any ambiguity.

 vix.input.1.et.regex = /year(=\d+)/month(=\d+)/day(=\d+)/hour(=\d+)/
 vix.input.1.et.format = =yyyy=M=d=H
Get Updates on the Splunk Community!

Celebrating Fast Lane: 2025 Authorized Learning Partner of the Year

At .conf25, Splunk proudly recognized Fast Lane as the 2025 Authorized Learning Partner of the Year. This ...

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...