Get the Text from PDF with specific format

[Ralph_Sena26 (ralph sena)]

Hi,

Newbie here.

I have a PDF that has account number, check number and amount.

Format below:

Account No.
123456-12345-1
654321-54321-0
098765-56789-1

Check No.
0000123456
0000654321
0000987654

Amount:
1,234,567.00
1,234.00
5,432.00

I already get the Check no. using Matches activity Pattern: “0000\d{6}”.
How to get the account no and amount using Matches activity?

Thanks,

[Yoichi]

Hi,

How about the following pattern?

Account No.

\b\d{6}-\d{5}-\d{1}\b

Amount

\b(\d{1,3},)*\d{1,3}\.\d{2}\b

Regards,

[Ralph_Sena26 (ralph sena)]

you’re amazing @Yoichi

Happy automation to all.

[Yameso (Jakub Swiderski)]

Check no has now 4 “0” but I guess, when it grow it could has format 000\d{7}