Jump to content

Importing from Word???


This topic is 6554 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies


I need to import contents from a Word file into Filemaker, I've heard that it's possible with something called Parsing, but I have no clue how that works. I'm designing a solution for people who would have different questions on the Word file, so would need some kind of solution where there is possibly a chance of putting the question into a field of its own as well as putting the answer into a field... Is there a script that I could write so that it could be attached to a button so it is nice and easy for low-tech users?

Thanks in advance,


Link to comment
Share on other sites

Hi Charly,

Parsing refers to breaking up a long stream of text to find its meaningful parts. You could look at the text functions to get an idea where to begin. You'll need to get familiar with functions like length, left, right, leftwords, right words, substitute, and the like. Basically you'll be looking for "tags" in your text stream like "Question 1:" and "Answer 1:", and breaking up the text from there. You'd probably also want to export from word to plain text to get rid of all the formatting codes first.

But honestly, I'd rethink using Word as a data entry tool if at all possible. It would be much easier for people to supply the data on an on-line html form that you could bring into FileMaker. Or off-line, think about using Excel. Otherwise, you are going to have a lot of parsing to do. Moreover, the limit of an FM text field is 64,000 characters, so you'll be limited in how much you can read.


Link to comment
Share on other sites

This topic is 6554 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.