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:
Right as your first string has word chars for the month, not digits. So, a
straight forward, if only lightly useful one would get both, but as they've
got entirely different orders, you're not going to be able to do much with
the result. You'd be better off looking at 2 separate ones, esp. if you
know one will be prefixed by "upgrade" and the other by "apply" or some
similar list of words:
if ( $str =~
/upgrade.sql\s+on\s+(\d{2}-\w{3}-\d{2})\s+(012][0-9]:[0-5][0-9]:[0-5][0-9])/
# got $1 eq "date-mon-year" and $2 eq "hr-min-sec"
or $str =~
/apply.sql\s+on\s+(\d{2}\.\d{2}\.\d{2})\s+([012][0-9]:[0-5][0-9]:[0-5][0-9])/
# got $1 eq "date.month.year" and $2 eq "hr-min-sec"
) {
# date str's matched
> I need a common regex which matches both the lines ?
You might want to let us know why? What you're going to do w/ the match.
Are you validating the strings and, if so, will you reject non-matches?
Are you looking to break them up into parts, $date, $mon, $year ... ?
Compare them, maybe to find the difference? Are these the only 2 formats
you'll be looking at, that is, maybe some might be 17.10.2018, or 17-10-18?
On Mon, Nov 12, 2018 at 6:49 AM Asad <asad.hasan2...@gmail.com> 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
>
--
a
Andy Bach,
afb...@gmail.com
608 658-1890 cell
608 261-5738 wk
