Scrape Field Value Data from PDF using UIPath

Question

I want to scrape data from the “w2 form” (pdf) so that i can use it to save into database but not able to get field wise data.

1. I have tried “Read PDF text” which reads the whole document fetches all text but i want to find field wise values like,

   Employee’s social security number => 1234 56 7890

   Employer identification number => 11-22334455

2. I have tried “Screen scraping”, “Data Scraping” but not able to get any specific element.

3. I have tried “Anchorbase” activity with “Find image” and “Get Text” but not able to select specific element.

Please find attached pdf document for your reference.

W2 Form pdf

Any help will be appreciated.

Thanks.

Answer 1

This is fully readable .pdf file, so this shouldn't be a problem to achieve this. You have to read document text and next use Regex to find what you want. Social security number or Identification number are rather structurized data so you can build regex expression easily. https://regex101.com/ can be helpful for this.

You have to:

1. Use Read PDF Text activity to get text of .pdf,
2. Assign activity, create new variable of type System.Text.RegularExpressions.Match
3. Import namespace: System.Text.RegularExpressions
4. On the right side of assign use: Regex.Match(readedText, "\d{2}-\d{8}") in quotes there is regular expression for Employer identification number,
5. If UiPath shows that 'Regex' is not declared, save the workflow, close it, open again, import namespace again, delete assign activity and create it once again.
6. That's all, in the same way you can find second number.

edit. example.xaml