Importing a fixed-width document?

[aaroncp]

Hello. I am using FileMaker Pro 9 and cannot seem to figure out how to import a fixed-width file.

I have a file that has one record per line, using a fixed-width format -- no commas, tabs, etc...

When trying to import into FileMaker, it sees each line as one record. There are no options I can find for setting the widths of the columns, a la Excel.

Ultimately my goal is to automate this process so the text file is processed every day and imported into our database, but I gotta get past step one first. Any help is greatly appreciated.

Aaron

[comment]

You need to do this yourself, by importing into a single field, and making other fields auto-enter a calculated result, using the Middle() function.