How to extract certain patterns using regex in UIPath?

Help Activities
, ,
1

I have the ff ouput below the data i have extracted from PDF. I wanted to extract the ff data from the output and achieve the ff result.

NOVUS HOME MORTGAGE
BK OF AMER
CPORT CU

but my current regex can only get CPORT CU. Any idea , thank you.,

Screenshot 2020-09-11 212204
Screenshot 2020-09-11 212204702×412 29.1 KB

output
output719×136 13.1 KB

2

Hi,

Can you try the following pattern with Mulitiline option at RegexOption of Matches activity.

"(?<=\d{3,8}\s+)[A-Z].*?(?=\s+[A-Z]{3}\s*$)"

Regards,

1 Like
3

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