String Manipulation issue

I have a string as “Open Account xy 10 july 2017Migrated Account abc on 11 April 2018”.
How to extract the date corresponding to Migrated i.e 11 April 2018

Hi @Amrita,

You can use regex to get the date.

Regards,
Arivu

Could you pls help with the pattern.

Thanks in advance

The below pattern extracts the date after the matching word “Migrated

Regex expression:
(?<=Migrated)(.*)(\d{2}\s(\wJanuary|February|March|April|May|June|July|August|September|October|November|December)\s\d{4})

From the matching regex groups take the Group2.

Sample code is here how to extract the groups from the matching strings -

https://docs.microsoft.com/en-us/dotnet/api/system.text.regularexpressions.match.groups?view=netframework-4.7.2

Regards,
Karthik Byggari

Pattern 1 : (Migrated.*)

First use the first pattern

Pattern 2: (\d{2} [a-zA-Z]* \d{4})

Regards,
Arivu