how to extract information from a pdf using regex and send that information to an excel spreadsheet

0 votes
Apr 8, 2020 in RPA by anonymous
• 120 points
649 views

1 answer to this question.

+1 vote

You can use the following high level activities to achieve this:

  1. user Read PDF Text activity and you will have the content as a string
  2. Perform Regex operations to get the exact data from that string. 
  3. Assign the values to specific Variables (Use assign activity)
  4. Perform Excel activities, to write there the information from variables.

 

answered Apr 9, 2020 by Karan
• 19,590 points

Related Questions In RPA

+3 votes
1 answer

How to extract data from a website and save it to excel using UiPath?

Hi Piyush, if you want to extract ...READ MORE

answered Mar 8, 2019 in RPA by Anvi
• 14,150 points
15,644 views
0 votes
1 answer

How to extract table and text from pdf file and load into Excel by using workbench commands in automation anywhere

Hey Dhruv, to extract table and text ...READ MORE

answered Oct 10, 2019 in RPA by Abha
• 28,020 points
2,411 views
0 votes
4 answers

How to find the sum of 2 columns of an excel and display it in a 3rd column using UIPATH?

These are the steps to add two ...READ MORE

answered Aug 2, 2019 in RPA by Shivi Singhal
7,995 views
+2 votes
1 answer

How to extract data from website and save it to excel using Blue Prism?

Hey, you can use following steps to ...READ MORE

answered Aug 19, 2019 in RPA by Abha
• 28,020 points
3,346 views
0 votes
1 answer

How to open an excel file with a dynamic file name such that the file name is FXTB-(date today) using UI Path.

Hey Alza, I am trying to understand ...READ MORE

answered Oct 14, 2019 in RPA by Abha
• 28,020 points
2,150 views
0 votes
1 answer

RPA : How to extract specific data from scanned pdf and write into excel in blueprism?

Your query is similar to https://www.edureka.co/community/6509 ...READ MORE

answered Mar 23, 2020 in RPA by Sirajul
• 59,030 points
876 views
+1 vote
0 answers
+1 vote
1 answer

How to automate iOS devices using UiPath?

As we all know it, there’s no ...READ MORE

answered Aug 10, 2020 in RPA by Karan
• 19,590 points
420 views
0 votes
1 answer

when to use ReframeWork with Orchestrator and when to use it without ?

UiPath Orchestrator provides basic reporting capabilities: for ...READ MORE

answered Nov 29, 2019 in RPA by Karan
• 19,590 points
761 views