topic Re: TIME_FORMAT regex help in Getting Data In

TIME_FORMAT regex help

Esky73 — Tue, 31 Jan 2017 06:13:46 GMT

12/02/2015 12:00:00 AM, Execute time: 0150

looking to extract the date and the 24hr time pls

Re: TIME_FORMAT regex help

harshal_chakran — Tue, 31 Jan 2017 06:54:05 GMT

Try this:

rex field=_raw "(?ms)^(?P\d{2}\/\d{2}\/\d{4}\s+\d{2}:\d{2}:\d{2}\s+\w{2})"

You can use Splunk's "Extract Fields" from Event Actions to perform the same.

Re: TIME_FORMAT regex help

Esky73 — Tue, 31 Jan 2017 07:06:02 GMT

hi thanks - i'm trying to do this in a props.conf file - not in a search

Re: TIME_FORMAT regex help

jplumsdaine22 — Tue, 31 Jan 2017 09:28:03 GMT

See here for the time format variables
https://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Commontimeformatvariables

Assuming the date is month/day/year and the time is a 12 hour clock (not 24 hour as you say), try
TIME_FORMAT = %m/%d/%Y %I:%M:%S %p

Re: TIME_FORMAT regex help

Esky73 — Tue, 31 Jan 2017 13:12:29 GMT

it is definitely 24h - thanks i'll try first thing in the morn

Re: TIME_FORMAT regex help

jplumsdaine22 — Tue, 31 Jan 2017 13:37:35 GMT

If its 24 hours, why does it have a AM/PM ? 16:00:00 AM wouldn't make much sense!

Re: TIME_FORMAT regex help

Esky73 — Tue, 31 Jan 2017 13:47:01 GMT

i see your point - however, further entries:

12/02/2015 12:00:00 AM, Execute Time: 1415
12/02/2015 12:00:00 AM, Execute Time: 1500
12/02/2015 12:00:00 AM, Execute Time: 1515
12/02/2015 12:00:00 AM, Execute Time: 1315