How to Extract the text in the angular brackets/Header from a word document and paste those headers in an excel sheet, please can anybody help me on this

[chetkurie_pavani]

How to Extract the text in the angular brackets/Header from a word document and paste those headers in an excel sheet, please can anybody help me on this.

[Anil_G (Anil Gorthi)]

@chetkurie_pavani

Welcome to the community

Can you please share a sample input and required output

Ideally you can use word activity to read and regex to extract the data from it

Cheers

[chetkurie_pavani]

Need to extract the headers from a word documents and paste those headers in an excel sheet.

[chetkurie_pavani]

[supermanPunch (Arpan)]

@chetkurie_pavani

image1168×582 7.45 KB

Hi @chetkurie_pavani ,

Are you trying to extract the Table from the Word Document ?

If so, You could Check the below post :

Converting Pdf table to excel

@Amit_Kumar_Charde , In that case, we should be able to read the PDF data using PDF Activities and apply String/Regex manipulation to get the data into a Datatable format. Is it possible for you to provide us with the PDF document or a Sample of that PDF having the same pattern of data as the original PDF document ? We could check if a String/Regex manipulation would be an easier approach for the pattern of PDF data that you receive. Additionally, Could you Check with the below workflow : P…

The Post above is mentioned for PDF document, but it also can be used for Word Documents as well.

Let us know if this is not working or not the expected solution you’re looking for.

[chetkurie_pavani]

word file has the combination like this , from the file I need to extract all the headers and sub headers and paste it in excel sheet (1st column ) and angular brackets data should paste it in 2nd column of excel sheet.

[supermanPunch (Arpan)]

@chetkurie_pavani

word file has the combination like this , from the file I need to extract all the headers and sub headers and paste it in excel sheet (1st column ) and angular brackets data should paste it in 2nd column of excel sheet.

@chetkurie_pavani ,

Have you Checked the post provided above ? Was it not able to extract the table data ?

[chetkurie_pavani]

Thankyou for you Response , I Tried But It’s not working with my word doc.

[supermanPunch (Arpan)]

@chetkurie_pavani

I Tried But It’s not working with my word doc.

@chetkurie_pavani ,

If the workflow when executed with your Input word document, did not create an Excel file. Then Could you Check the Output Panel and provide a Screenshot of it here ?