How to extract "dd-MMMM-yyyy" date from string

Input:
Reviewed in India on 20 July 2020

Output:
20 July 2020

Can anyone share regex for this?
Thanks

Hi @NervousTuber

Try the below expression
System.Text.RegularExpression.Regex.Match(“Reviewed in India on 20 July 2020”,"\d{2}\s\S+\s\d{4}")

Hope it works

Regards
Gokul

Refer the regex Link

Regards
Gokul

THanks its working

1 Like

hey,
image
this is my excel data i want to remove “Reviewed in India on” but Country name is not static its dynamic.

I want to remove it from final output excel sheet. is there any way to do this?

I suggest to create a new topic for this query. it will be bit more useful for other who searching for this query with your are asking

Regards
Gokul

1 Like

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