Extract the value using regex

Help Something Else
1

image

I am trying to get the amount value but I am not able to extract. Please suggest me some regex for extracting the amount. Also I am using multiple invoices to get multiple amount in words.

2

Hi @Lokesh_Raj_R_M

You can try With Substring method .

please refer to the attached xaml below.

RegexSplitting.xaml (4.3 KB)

Regards

3

Thanks @pravin_calvin
But I am using multiple invoices and each time I need to get amount in words from different invoices.

4

Hi @Lokesh_Raj_R_M

Give it a Try and let me know if this works

Regards
Sudharsan

5

Hi @Sudharsan_Ka
Thanks for the regex code. I tried it in UiPath but it is not able to extract the data. Also FYI, I am using assign activity.

image
image820×52 3.69 KB

Regards,
Lokesh

6

Can you able to share the pdf?

7

I am sharing the text file.
invoice.txt (1.5 KB)

8

This is the text file with formating?

if not send me with formatting

image
image1047×499 24.7 KB

9

Since I am using Read PDF activity once the invoice data has been fetched, it will be similar to the data in the text file.

10

image
image1843×885 85.4 KB

11

@Lokesh_Raj_R_M

image
image1193×373 90.7 KB

12

invoice-1.txt (5.6 KB)
@Sudharsan_Ka

13

The Same regex is working here

Check once and tell me

14

Please try in this website.

15

Have you tried the regex running in Uipath?

16

yes and it is not able to extract the data

17

Can you able to share Workflow here or personaly?

18

Give a try on following for handling Windows Linebreaks compoesed by \r\n as well

grafik
grafik766×469 27 KB

19

Thank you @ppr and @Sudharsan_Ka .