Primary Payer: XYZ Comany
Member ID: ABCD123ACD
Secondary Payer: YXZ Company
Member ID: XYZ32R390AD
Tertiary Payer: MNO Company
Member ID: FLMN3333MMMN
This above 3 are input we received in website need to extract Member ID for each of payer key word is Primary Payer, Secondary Payer and Tertiary Payer
need to extract Member Id using Regex can you give me correct Regex to extract it
Expected output :
ABCD123ACD
XYZ32R390AD
FLMN3333MMMN
Thanks,
Vicky
hey @Vicky_K, Try (?<=Member ID:) .*
(?<=Member ID:\s)[A-Z]+\w+
Hi,
If you need to extract them separately, the following will help you.
Primary Payer
System.Text.RegularExpressions.Regex.Match(yourString,"(?<=Primary Payer:.*\r?\nMember ID:).*").Value
Secondary Payer
System.Text.RegularExpressions.Regex.Match(yourString,"(?<=Secondary Payer:.*\r?\nMember ID:).*").Value
Tertiary Payer
System.Text.RegularExpressions.Regex.Match(yourString,"(?<=Tertiary Payer:.*\r?\nMember ID:).*").Value
Sample20230724-1L.zip (3.9 KB)
Regards,
Hi @Vicky_K
Use the below regex expressions.
System.Text.RegularExpressions.Regex.Matches(yourstringinput.ToString,“((?<=Member ID:\s+).*)”)
Hope it helps!!
(?<=Member.ID: ).*
If you got the solution for your query. Please mark it as solution to close the loop.
Regards,
Hello @Vicky_K! Try this:
Primary Payer:\s*(\w+).?Secondary Payer:\s(\w+).?Tertiary Payer:\s(\w+)
Hope it helps 
Thank you @Vicky_K
Happy Automation!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
