How to Extract Data from Word File

[sachin_sharma]

i have image file in pdf format i convert that image file in word file using ocr software now i want to extract some field data like Order Number,Invoice Date,Address,Firm Name and Table please help me i have attached the word file

[Palaniyappan (Forum Leader)]

Hi
We can use word package and read the file which gives us string value as output
Then using string manipulation with Regex or split method we can get the value we want

Cheers @sachin_sharma

[sachin_sharma]

Hi i follow the step as you advice but my out put is coming in wrong format please look

[Pradeep_Shiv]

put this in text file and use that text to write Regex Pattern on it!

[Mayur_Pawar]

get that output in file .txt and than apply regex on that @sachin_sharma

[sachin_sharma]

but how to apply regex for Firm Name and Address Please look the First image .
Thanks for reply

[Pradeep_Shiv]

@sachin_sharma

irm Name a

get that in notepad and post it here we will see! @sachin_sharma

[sachin_sharma]

please see this png file

[Pradeep_Shiv]

after reading pdf text or image the content may change or it differs
thats the reason we are asking you to show the sample!
anyway you can extract firm name like this (?<=Firm Name).*(?=Read Office:)
and address like this (?<=Address:).*

[sachin_sharma]

hi the first image i attached that file is in word format i have attached the file in image format because there is no option to attache the word file in forum

[Pradeep_Shiv]

convert it to string and use the above regex!

[Palaniyappan (Forum Leader)]

Hi
Did we try with the method suggested here

How to read table in a Word document

Is it possible to read a table in a section of a Word document using UiPath. Can this be done using any of the existing Activities available in UiPath or should we download any third-party activity?

Cheers @sachin_sharma

[mitesh_parmar]

Hi @sachin_sharma,

(?<=Address)\n.* use this to get Name value and put it into variable
(?<variable.Trim)\n.* you will get office name.

[sachin_sharma]

hi thanks for reply but first see the the output format of word document

this is the output i get from word file now suggest what can i do

[sachin_sharma]

hi @ mitesh_parmar
please see the output file i attache

[Palaniyappan (Forum Leader)]

No buddy
Actually this method converts the word to excel and from excel we can access the row value we want
Did we try that method

How to read table in a Word document

Is it possible to read a table in a section of a Word document using UiPath. Can this be done using any of the existing Activities available in UiPath or should we download any third-party activity?

Cheers @sachin_sharma

[sachin_sharma]

Hi @ Palaniyappan
i try using send hot key ctrl+g ,ctrl+c but hoe i get the output for ctrl+c command

[Palaniyappan (Forum Leader)]

Fine use a START PROCESS activity and pass the filepath of word document as input to Filename property

Now use a SEND HOT KEY activity and mention the key as ctrl+a
Then another hot key with key as ctrl+c

after copying inside the word document use a START PROCESS activity where pass the filepath of new excel file you have created to the property FileName
This will open the excel file and now use a SEND HOT KEY ACTIVITY with key as ctrl+v

Cheers @sachin_sharma

[mitesh_parmar]

No output file is attached ? @sachin_sharma please attached it again.

[sachin_sharma]

HI @ mitesh_parmar please see the message box image i attached