How do I import Word-documents (one Doc per record) and parse into files,records,fields using a script
Posted on 2006-06-26
I have 200 rather wild word-documents that I wish to import into a Filemaker db.
Documents contain personal information and look like this:
Name: <space or TAB chars used to format> Joe Blogs
Address: 56 Smith Road, Kingstown, NY 12345
condition 3 (can be many)
Mr. J. Blogs
44 Bloggs Road
There can be more than one blank-line between "headings".
I know how to import a TXT document but the problem is obviously that the data is organised vertically and each "record" is in a seperate Word-file.
Any suggestions for a script that would parse these files into the appropriate files, records and fields?
The FileMaker DB is structured like this:
The Names-files has fields for: FirstName, LastName, DOB, Address1, Address2, City, State, ZIP, SSN, MedicareNo.
There is a Join-file to link Names with Family members (can be more than one, at times 4 family addresses need to be stored.
There is a NOK-file for family member details: Name,Addr1, Addr2, City, State, ZIP, Phone1, Phone2
There is a Join-file to link Names with medical conditions (can be one to up to 20 conditions per person)
There is a MedicalCond-file: Name, Description.