Hi all, I have pdf file [InvoiceNo] like this and i want to get all data in proper manner in csv file.i tried multiple ways to extract data but columns are not coming in proper way.

HI @sayali_rokade You can do couple of ways… Download the PDF file and open it in Adobe reader… Then do Data Scraping on the PDF file Next, you can use UiPath Document Understanding to extract the values

which data scraping i tried but all data save in single column

Did you use the Data Scraping wizard that you can find on the top menu of Studio?

yes i used but not getting teble data in excel properly

@sayali_rokade Can you share a sample pdf file? Thanks

i have shared u screenshot, [InvoiceNo] i have one pdf file and i want to get invoice no,amount and all fields in proper format in excel or csv

Please upload the pdf file not a screenshot.

i dont have access to upload PDF file thats why i send u screenshot

@sayali_rokade - could please use read pdf text activity and set preserve format to true and save the output to String variable. Then use write text file activity and share the text file here.

thanks for reply my text file is Test1_page1 (2).txt (1.6 KB) so i want data like Invoice Number 108027883 Document Number5001211394,Document date28/12/2020 ,Invoice Amount486167.80,Deductions 0.00 and Net Amount486167.80 like this data in excel in diffrent column.pls help me if u know

PDF Data Extraction in csv

Help Activities

prasath17 (Guru) April 9, 2021, 12:45pm 12

Hi @sayali_rokade - Please find the starter help here… Regex_SR.zip (44.2 KB)

Regex pattern link : From here you can learn how the pattern has been derived…

Hope this helps…

Data extraction from text to excel

Topic		Replies	Views
Urgent for scraping pdfs Academy Feedback uiautomation , activities , question	3	874	March 1, 2021
Unstructured PDF to excel or csv Help excel , pdf , csv , activities , data_scraping , question	9	1293	January 20, 2020
Extract Pdf Data into Excel Help activities	6	1204	March 29, 2019
How to extract specific data like invoice no, supplier code from multiple invoice pdf with same layout? Help excel , pdf , activities , question	8	2330	November 28, 2019
Extract scanned PDF to excel Studio	4	5108	August 12, 2020

PDF Data Extraction in csv

Related topics