Fetching the data from pdf files

Help Studio
, ,
1

There are around 30 pdf files I want fetch the amount from the each file, if the pdf is not contain any amount then i need to ignore that pdf file, if the pdf contains amount then i need to take the amount and write into the excel file.

Can anyone please help me to solve the above automation.

Thank you in advance.

2

Hi @HeartCatcher

Can you send the sample pdf? or just send the image of the amount in the pdf file

1 Like
3

Hi @HeartCatcher,

A simpler approach is to read PDF files using https://docs.uipath.com/activities/docs/read-pdf-text and check if required text is present or not using string.contains
If amount is a number, you can make use of Regex for searching amount.

Thanks,
Saranya K R

1 Like
4

Hi @HeartCatcher
The general structure you can solve ur issue is

  1. Use assign actity to get the list of all pdf files in that folder using assign activity

files_list=Directory.GetFiles(folder,“*.pdf”)

  1. use Build datatable with required columns where u need to add amount data and store dt1 datatable variable.

now use for each to loop through each file (for file in file_list ) with type argument as String
inside it use the below activities

a. Use Read PDF activity to read the pdf and store in string input_text

b. U can use isMatch or contains method to validate whether the amount is present there or not

c. if the above expression is true, then extract the amount data by using Regex or string manipulation and store in datatable using add datatrow activity to add amount data in dt1.

d. if the expression id false, then use continue action to skip the current iteration and move to next one.

Hope it helps
Mark it as solution if it solves ur query
Regards,
Nived N

1 Like
5

Hi @HeartCatcher

Here is a sample Template

PDF.xaml (6.6 KB)

Let me know if you need help

6

@Gokul001

BlankAmount
BlankAmount994×139 7.3 KB

Received amount
Received amount992×141 9.75 KB

please find the attachments

7

Hi @HeartCatcher

Can you able to send the sample file? for extracting the amount from the Pdf file

9

I need a sample Pdf file

10

PDf File no data
PDf File no data1008×363 14.6 KB

Pdf with data1
Pdf with data1975×422 45.1 KB

@Gokul001 pfa

11

Hi @HeartCatcher

Whether the marked one remains constant?

image
image980×423 46.3 KB

12

@Gokul001 its not constant.

For each session there will be 2 files
:black_small_square: Presentation(presented column) File
:black_small_square: Return(received) Settlement File.
File name with _R is a return settlement file and file without R is the presentation file.
ACHCR is credit Settlement file and ACHDR is debit settlement file."

13

Capture
Capture883×288 17.9 KB

14

Hi @HeartCatcher

Can you able to send sample text file with a preserved format

15

Hi @Gokul001

There is no text file , I have pdf and master excel. May I please which text file you are looking for??

16

May I Please know****

17

Create a sample workflow

  • Use Read pdf Activity (In properties → preserve format as “TRUE”)
  • Print the text in a Notepad file. using write file Activity
  • Send me the text file
18

PPdf.txt (672 Bytes)
@Gokul001

19

Hi @HeartCatcher

What value i want to extract from the file can you please tell

20

@Gokul001
8,785,915.00
-7,266,377.52
1,404,716.48

Above values which are under presented, received , net bilateral respectively

Sorry for the inconvenience

21

Hi @HeartCatcher
Here is the sample workflow
PPdf.txt (672 Bytes)
Regex.xaml (7.4 KB)
Let me If you face any issues.