Is there a way to parse data from MSWord into an FM database? I get several Curriculum Vitae in everyday and currently I have to cut and paste all the data into my application. Most of the CV's come in via email in a word doc. Some pdf. I would like to be able to parse the Name/address/phone/email data into their respective fields as well as store the content in another text field.

Any ideas, suggestions, plugins, whatever?

Thanks for your help.

Al

Using VBscript you can get the pure text content of the word document into a FM field. That would give you the ability to do the text parsing in FM.

Unfortunately FM doesn't have regular expressions for that. VBscript does though so if you're more comfortable with that, you can do all the parsing in your VBscript code and then just bring in the results into FM. Check out the "Windows automation" forum for more info on using VBscript from FM.

Can you give me the proper link? I tried to Google it and didn't find what I expected. The listings were more for windows scripting software than a forum for windows automation.

Thanks for your help.

Al

http://fmforums.com/forum/showforum.php?fid/38/