Assign - RegEx Unrecognized escape sequence

I’m not familiar with RegEx but I was able to Google and fail my way into an expression on https://regexr.com/. When I run it in UiPath though it’s returning an error:

Assign - Supplier: parsing "(?<=\|76 )(.*?)(?=\_)" - Unrecognized escape sequence _.

After check a few forum threads I tried the following but neither is producing the desired results.
Assign - Supplier: parsing “(?<=\|76 )(.*?)(?=(\_))” - Unrecognized escape sequence _.
Assign - Supplier: parsing “(?<=\|76 )(.*?)(?=\\_)” - This one doesn’t error, but returned no value. It also doesn’t highlight the data in regexr.

Sample data:
85 1000_Corporate Office|76 1234567_THE ABC CORP~MAIN_PURCH_PAY|71 9|
85 1000_Corporate Office|76 1234567_THE ABC CORP~MAIN_PURCH_PAY|71 19_002|
85 1000_Corporate Office|76 1_THE BANK OF HMD CHRON~REM01_PURCH_PAY|71 1565|
85 1000_Corporate Office|76 987_THE UNION BRANCH-MITSUBISHI~REM02_PURCH_PAY|71 12345K|

Desired results:
1234567
1234567
1
987

(?<=\|76 )(\d+)

1 Like

Thank you!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.