You could change the first portion of RegEx to
\d{2}[.\-](\d{2}|\D{3})[.\-]
This could cover all the valid Month codes, but this will look for the hyphen
or period and two digit month or three non digits and then the the hyphen or
period following. There is much more you could do, but this covers the initial
start.
Did not test, but believe it should find both items...
Wags ;)
WagsWorld
Hebrews 4:15
Ph(primary) : 408-914-1341
Ph(secondary): 408-761-7391
On Nov 12, 2018, 09:37 -0800, Asad <[email protected]>, wrote:
> Hi all ,
>
> I have two stings from logfile how can we have a common regex so
> that its parse datetime details for further parsing ;
>
> Calling upgrade.sql on 05-JUL-18 10.19.42.559000 PM -12
> Calling apply.sql on 17.10.18 12:28:12,447849 +02:
>
> I created on regex : \d\d\.\d\d\.\d\d\s[012][0-9]:[0-5][0-9]:[0-5][0-9]
> this only matches : Calling apply.sql on 17.10.18 12:28:12,447849 +02:
>
> I need a common regex which matches both the lines ?
>
>
> Thanks,
> --
> Asad Hasan
> +91 9582111698
