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

0 votes
Apr 8 in RPA by anonymous
• 120 points
45 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 by Karan
• 10,080 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,050 points
10,476 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
• 27,920 points
1,277 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
5,205 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
• 27,920 points
1,655 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
• 27,920 points
752 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 in RPA by Sirajul
• 52,930 points
203 views
0 votes
1 answer

How to delete some specific sheets from an existing excel file using vb.net code?

You can create a output of Excel ...READ MORE

answered Jul 27, 2018 in RPA by Atul
• 5,530 points
1,041 views
0 votes
1 answer

How to extract specific type of files from a directory using UiPath?

Hey @Avani, if you want to extract ...READ MORE

answered Mar 13, 2019 in RPA by Anvi
• 14,050 points
4,267 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
• 10,080 points
330 views