Regex pattern in between texts

[lynnsong986]

Hello,

I have the below sample strings where I need to extract
Dec. 28 Dec. 29 USD97.46@1.319823517 DESIGNS FOR HEALTH 8008478302 CT 014000576995 128.63
Dec. 30 Dec. 31 USD1,667.01@1.314755160 EconomyBookings.com 1 202 800 993LVA 000046645013 2,191.71
Dec. 30 Dec. 31 MANULIFE TRAVEL INSURA TORONTO ON 800175645626 112.12 CR

everything after the second date but before the reference
USD97.46@1.319823517 DESIGNS FOR HEALTH 8008478302 CT in line1
USD1,667.01@1.314755160 EconomyBookings.com 1 202 800 993LVA in line2
MANULIFE TRAVEL INSURA TORONTO ON in line3

can someone please help?

[Gokul001 (Gokul Balaji)]

Hi @lynnsong986

Try this expression

System.Text.RegularExpressions.Regex.Match(InputString,"(?s)(?<=\S{3}.\s\d{2}\s\S{3}.\s\d{2}\s).*?(?=\d{12})").ToString

Regards
Gokul

[lynnsong986]

@Gokul001

(?s)(?<=\S{3}.\s\d{2}\s\S{3}.\s\d{2}\s).*?(?=\d{12})

Thanks so much Gokul, however some lines aren’t returning

[Subham_Don]

Hello,

Try this

(?<=\S{3}\.\s\d{1}\s\S{3}\.\s\d{1}\s).*?(?=\.*\d{12})|(?<=\S{3}\.\s\d{1}\s\S{3}\.\s\d{2}\s).*?(?=\.*\d{12})|(?<=\S{3}\.\s\d{2}\s\S{3}\.\s\d{1}\s).*?(?=\.*\d{12})|(?<=\S{3}\.\s\d{2}\s\S{3}\.\s\d{2}\s).*?(?=\.*\d{12})

Regards
Subham Don

[Subham_Don]

just modified Gokul’s answer a bit

[Yoichi]

Hi,

FYI, the following expression might be better.

mc = System.Text.RegularExpressions.Regex.Matches(yourString,"(?<=^[A-Za-z]{3}\.\s+\d{1,2}\s+[A-Za-z]{3}\.\s+\d{1,2}\s+).*(?=\d{12})",System.Text.RegularExpressions.RegexOptions.Multiline)

note: mc is MatchCollection type

Regards,

[Gokul001 (Gokul Balaji)]

Hi @lynnsong986

You can try with OR | operator in the regex expression

System.Text.RegularExpressions.Regex.Match(InputString,"(?s)(?<=\S{3}.\s\d{2}\s\S{3}.\s\d{2}\s).*?(?=\d{12})|(?s)(?<=\S{3}.\s\d{2}\s\S{3}.\s\d{1}\s).*?(?=\d{12})|(?s)(?<=\S{3}.\s\d{1}\s\S{3}.\s\d{1}\s).*?(?=\d{12})|(?s)(?<=\S{3}.\s\d{1}\s\S{3}.\s\d{2}\s).*?(?=\d{12})").ToString

Regards
Gokul

[lynnsong986]

Thank you all! it works well now!