I have converted a pdf file to RTF and I want to import it (3 fields) into a table. The fields consist of a part no., description, price. This where I get lost. Any help would be appreciated. I have attached a sample of the data file.

sample.zip

Hi IEW,

Save you Word document as simple text and add line breaks with CR only. In FM create a field to import each record into, then parse the data in that field to get your part no, description and price. I am attaching a sample. The calcs in the sample will work if your data is formatted exactly like your sample file. The calcs are looking for occurances of spaces to parse the data.

Hope this helps,

Steve

import_sample.zip