Date extraction from txt or string data

[sachin1987]

Hi All,

I am trying to extract data from the below input. I tried using some Regex, but was unable to achieve the desired results.

Input	Output
	Formed Date	Commenced Date	General Partner
was formed as a Cayman Islands exempted limited partnership on June 12, 2014 and commenced operations on September 1, 2014. ABCD was wholly owned and capitalized by	12-Jun-14	1-Sep-14
ABCDs, L.L.C., a Delaware limited liability company and registered as a foreign company in the Cayman Islands (the "General Partner"), serves as the general partner of the Partnership.			ABCDs, L.L.C.

Can someone help how to get the data as put in Output section.

Thanks in advance!

[AkimasaKajitani · Accepted solution]

Hi @sachin1987 ,

I don't know all the rules in this text. However, I make the Regex expression that work only with this input text.

on\s(\w+\s\d+,\s\d{4})

(^\w+,.*?),

If I would know more other rules, my expression will be changed.