Extract Specific date using keywords

Hello,Guys

For Example This is my text “effective closing hours of August 14, 2019.
We thank you for your services”

So i’ve to take key word as “Hours” and Extract August 14,2019.

using regex if possible

Hi @Pradeep_Shiv

Like this give the expression as(?<=Hours).*
With is match activity
Thanks
Ashwin S

it’s Taking the entire row like “august 14,2019. we thank you”

@Pradeep_Shiv,

Use the below regex

(?<=hours of\s).*?(?=\d{4})\d{4}

Hi @Pradeep_Shiv

try this

\d{2}.\d{4}

Thanks
Ashwin S

@Pradeep_Shiv
You mean the 14 alone?

The below regex give the whole date, see the image for the result.

1 Like

It’s Working Fine

Thank you @sarathi125

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.