Retrieve particular data from multiple word files using screen scrapping

Help
,
1

@loginerror @aksh1yadav @vikaskulhari @lakshman

Hi
I am having 50 word files … It’s an invoice … In all word document I am having the price at same place I need to retrieve the price and update to excel

How to do screen scrapping automatically…

Please provide the solution

Thanks in Advance

2

Could you post the file?

If every file is the same you could use String manupulation and Regex to get desired results (It is much faster and precise than Screen Scraping)

3

if any string is fixed in all the document, you can also use indexof and substring functions.

4

It’s an invoice bro

I’m having 50 word files in same format with different DOC No

I need to extract and update it in excel

image

5

image

It’s an invoice bro

I’m having 50 word files in same format with different DOC No

I need to extract and update it in excel

6

Could you attach one PDF file so we could try to work with it?

7

@Selva_murugan, Read the file and store into string. Now you can use string manipulation, or regex to extract the desired field.

Once you have extracted , use excel activities to write into the excel file.

Cheer!!

8

That’s not pdf bro it’s word document…And I don’t have access to upload the document

9

Capture-99
Capture-99739×756 13 KB

I am unable to upload the files but this is the format of the doc I have edited somewhat due to no leakage in data …And Here I need to capture the Doc No …There are 50 word files like this …I need to capture the document number and upload it to excel …

Please help as soon as possible … I have been stuck in this …

I hope it will be an challenge to our RPA family

Hope We will get an solution

Thanks in Advance my RPA family…

10

Could you use Read Text File Activity to read this and send us the results (with the edited data ofc). Then we can apply some string manipulations (if it is a Word document it can be read like that)