Making unstructured data into a structured format (MS EXCEL)

Making unstructured data into a structured format (MS EXCEL)

Closed - This job posting has been filled and work has been completed.

Job Description

The nature of this work is to take two files that are in a txt and doc format and transfer the content into a structured database format. For example, the first file which is called, "List_1"....this document has the following information I need in a database format:

College Name
Address
School Number
Last Accreditation
Next Accreditation
Contact Name
Phone
Fax
email
Web

I do not want this manually done. I want a program to be written to complete the task. There's a lot of data and doing it manually will cost too much and take too much time.

The second file which is called "List_2", has the following information:

College Name
ABHES ID
Address, city, state, zip
Phone
Fax
Initial Year Accredited
Currently Accredited through
Contact
Email
website

Same thing...I need those data points as columns in a spreadsheet. THE ATTACHED FILES ARE ONLY A SAMPLE. THERE'S MORE DATA IN THE FULL FILE.

Let me know if you can help. Thanks.
Vinnie

Open Attachment

Other open jobs by this client