Hello guys again,
Below here is an example of a job application form. There are a lot of these in a folder, and the format would stay the same. I would only want to extract the Name, Mobile Number, School, Highest Certification, Email Address, Home Address & the Position Applied and place all the data into an excel file. Is there a way to do this as I did try to do it but it is not working for me. I have put up the excel file where i would like to put the data in. Also i apologize as i could not upload the word file here.
Hi there,
This is just a school project where I am working on. I searched google for the template, deleted some of the content that I do not need. Below here is the link for word document.
If the file is in PDF format you can use OCR Activities to get the particular text and write it into excel file by first building the data table and then using Write Range activity.
First step is to build a datatable with all the information you want
Second step is to extract data from either word or pdf document into your datatable
(To do this you can use OCR Activities as @hasib08 has mentioned or string manipulation if extracting the whole file)
Final step is to write that datatable into your excel spreadsheet.
Hi, i need help to extract multiple word document or pdf document with similar format into excel spreadsheet.
Similar to the question ask previously.
I have multiple resume. I want to extract all this word or pdf file and put it into excel spreadsheet. Excel spreadsheet will have column of name, age, education level, work experience etc.
can you help me? The previous forum only stop half way. Thanks.