Extract PDF Invoice Data to Excel

Help StudioX
,
1

Good night everyone! Firstly sorry for the bad english. I need to extract some data from a PDF invoice and pass it to a table in Excel. My Adobe doesn’t allow that tagging configuration by TAGs and I’m not able to select the data in any other way. The robot cannot find the text to extract. Could you help me please?

2

You can try the following two methods to extract data from PDF file

  1. Use Table Extraction. Open PDF file in Acrobat reader->Use Table Extraction to extract datatable
  2. Use UiPath Document Understanding: Intelligent Document Processing - Document Understanding | UiPath

image
image903×143 16.2 KB

3

Hi @Danilo_Barreto

You try to do it in Regex expression

If possible can you share the sample PDF file and the output

Use Save For Later activity in StudioX

LHS - Create an variable
RHS - System.Text.RegularExpression.Regex.Match(“Input string”,“Your pattern”).Tostring

Use Assign activity in Studio

LHS - Create an variable
RHS - System.Text.RegularExpression.Regex.Match(“Input string”,“Your pattern”).Tostring

Regards
Gokul