topic Day Of Month Field Without A Leading Zero in Getting Data In

Day Of Month Field Without A Leading Zero

sajbutler — Thu, 05 Jul 2012 03:58:06 GMT

I have a log which contains entries like the following:

(3/07/12 13:13:09) 8856: < RingBufferModule::initialize()
(3/07/12 13:13:09) 8857: Finished init of: 'RingBufferLoggingAppender'
(3/07/12 13:13:09) 8858: Initializing 'AudioPathController'
(3/07/12 13:13:09) 8859: Unable to find value for key: 'SrxSupervisorAudioEnable'

The date component is day/month/year. So in the above example, we have the 3rd July 2012. As you can see, the day of month (i.e. 3 in the above example) does not contain a leading zero. According to strptime, %d represents 01-31 and there seems to be nothing for 1-31. I've tried the following in props.conf but to no avail:

TIME_FORMAT=%d%m/%g  %H:%M:%S

Any suggestions to this would be appreciated.

Re: Day Of Month Field Without A Leading Zero

yannK — Thu, 05 Jul 2012 05:00:48 GMT

There is a strange double space in your timeformat.

Also, you could try to add the characters around.

 

TIME_FORMAT=(%d/%m/%g %H:%M:%S)

Re: Day Of Month Field Without A Leading Zero

sajbutler — Thu, 05 Jul 2012 06:24:05 GMT

Thanks for the suggestions yannK.

I've removed the double space from the TIME_FORMAT and also tried enclosing in brackets but still no good.

Re: Day Of Month Field Without A Leading Zero

itinney — Thu, 05 Jul 2012 16:05:34 GMT

You are missing a slash after the %d and before %m in your first post.
I always use %Y for four-digit year and %y for two-digit year.
%d is always zero-padded (03/07/12)
%e is space-padded ( 3/07/12)
I would try:

%e/%m/%y %H:%M:%S

%e/%m/%y %T

Re: Day Of Month Field Without A Leading Zero

sajbutler — Mon, 28 Sep 2020 12:02:00 GMT

Missing slash. Ouch. The %e space pads and works fine. I can confirm that the following following config in props.conf works:
TIME_FORMAT=%e/%m/%g %H:%M:%S
TIME_PREFIX=[(]