I need to extract all the details from invoices

Help Studio
, ,
1

I need to extract all the details from invoices pdf and line item description quantity and all the fields without using Document understanding. Is it possible using regex
@Anil_G @supermanPunch @Sudharsan_Ka

image
image1687×431 15 KB

2

Here is text file
New Text.txt (1.6 KB)

3

@pravin_bindage

try

use read text file activity

then use generate datatable activity to fetch all the data

cheers

4

Can you elaborate more

5

@pravin_bindage

i tried but iam not extract all the fields using the generate datatable activity

cheers

6

image
image1736×1085 105 KB

7

image
image1450×778 89.3 KB

These regex pattern works when we have same pattern in the fields

8

Please let me know if this meets your requirement

9

its good but how to extract product description which is in multiple lines

10

I need a small clarification description in first row is
pressure or SENSOR DIFFERENTIAL?

11

Sensor diffrential pressure is the first item description & above of it its part no

12

Hi @pravin_bindage

Could you specify in bold what are the extraction outputs you need

Regards,

13

image
image1608×1074 108 KB

image
image1447×783 86.3 KB

use these two regex pattern to get the required and then join
I think it helps
please let me know if that works

14

Screenshot (294)
Screenshot (294)1623×615 66 KB

15

I highlighted column header & values which i need with same colors

16

@pravin_bindage

Can you explain more what are need to extract form this input

17

i need to extract item description & all other highlighted values

18

@Steven_McKeering can you help me?

19

Can you convert into text file and send then i will design a flow for you for sample

@pravin_bindage

20

I already uploaded text file earlier in this post
New Text.txt (1.6 KB)