String Manipulation issue

Help
1

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

2

Hi @Amrita,

You can use regex to get the date.

Regards,
Arivu

3

Could you pls help with the pattern.

Thanks in advance

4

image
image1319×249 18 KB

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.

image
image745×264 9.95 KB

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

Regards,
Karthik Byggari

5

Pattern 1 : (Migrated.*)

First use the first pattern

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

Regards,
Arivu