Regex to find data after balance

I want data which is I mark blod

Invoice date: 09/07/2021 balance: $290.00 American Steel Fabricators, Inc Attn: American Steel Fabricators, Inc 328 Sawmill Road

Invoice date: 09/07/2021 balance: $75.00 Atlantic Coast Surgical Suites Attn: Atlantic Coast Surgical Suites 325 Lafayette Rd.

Invoice date: 09/07/2021 balance: $20.00 AOS applya Occupational Strategies Attn: AOS applya Occupational Strategies 131 Falls Street

Invoice date: 09/07/2021 balance: $60.00 American Moving & Installation, Inc. Attn: American Moving & Installation, Inc. PO Box 2313

Hi @ashishmani

Can you confirm that you will have only 2 decimal after balance amt?

Regards
Sudharsan

not sure, but still you will take 2 digit after dot

Inside UiPath Matches or IsMatch activity you can input “(?<=(balance:\s$\d+.\d+\s)).*” in pattern.

1 Like

Hi @ashishmani

In case You need alternative

Regards
Sudharsan

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