How to extract the data from the pdf using regex i try but i fail

[copy_writes (chethan)]

Hi team i need to extract the data which is marked in blue

Invoice.pdf (323.5 KB)
I hope i get the solution
and i extract a few things like scored (3617) and purchase order and item number

but i dont know how to extract the UOM and QTY and 2000

I hope some one will help and i share a sample file to you in the above

thanks
Chethan P

[Sudharsan_Ka]

Hi @copy_writes
For UOM and QTY

regex101: build, test, and debug regex

From this what you have to do is
Take this whole string as array and split them like

• after getting the match of regex just store in a string (“Variable”)
• Another regex
  
  
  
  Store in a string variable “Str2”
• Assign a String of array Arr_Str= Split(Str2.Trim," ")
• and for UOM : Arr_Str(2)
• and for Qty : Arr_Str(3)

[copy_writes (chethan)]

@copy_writes

I hope you confused i need item which they marked by blue color

[Sudharsan_Ka]

@Sudharsan_Ka

From this what you have to do is
Take this whole string as array and split them like

• after getting the match of regex just store in a string (“Variable”)
• Another regex

Store in a string variable “Str2”

• Assign a String of array Arr_Str= Split(Str2.Trim," ")
• and for UOM : Arr_Str(2)
• and for Qty : Arr_Str(3)

This will get the UOM and QTY

[Sudharsan_Ka]

@copy_writes

and 2000

This Field remains constantly in the same place ( whether It will be always in the 4th line?)?

[copy_writes (chethan)]

yes its in the 4th line or 5th line some times

[Sudharsan_Ka]

Hello @copy_writes

Here is the regex for the 4th or 5th Line
Link: regex101: build, test, and debug regex

You can assign it by trimming it

Regards
Sudharsan

[copy_writes (chethan)]

Can you please explain how?

[Sudharsan_Ka]

You are asking the last one right?

[copy_writes (chethan)]

@Sudharsan_Ka

From this what you have to do is
Take this whole string as array and split them like

• after getting the match of regex just store in a string (“Variable”)
• Another regex

Store in a string variable “Str2”

• Assign a String of array Arr_Str= Split(Str2.Trim," ")
• and for UOM : Arr_Str(2)
• and for Qty : Arr_Str(3)

this one

[Sudharsan_Ka]

Yeah sure,

When you use the regex I mentioned before this step
It will take the whole first line as regex match like this

If we split this string by space it will take Str as 1st array ,huge as 2nd array and so on

If we use this “\S\s\s” pattern and replace it with “#” ,This will become one complete array

So that we can get the UOM and Qty in 2nd array and 3rd array

Regards
Sudharsan

[copy_writes (chethan)]

(.\n)\n(?=Contact) we can use this code? instead of this (.)(?:.*\n){2}.*Contact
Because in that we have to extract all extract space?

[Sudharsan_Ka]

Yeah You can use this also,

regex101: build, test, and debug regex

Thanks for sharing brother