Peter, Suggest going to http://www.briandunning.com and searching in the custom functions for "fixed".
There you'll likely find a custom function you can use in an auto-enter calc in each one of your fields to make the data fixed-length. Suggest using an intermediate table in order to avoid changing your permanent data. The auto-enter calc could work upon import into this intermediate table. -- Steve Gerow FileMaker 9/8/7 Certified Developer President Abrazos Data Consulting, Inc. Pasadena, California Member FileMaker Bus. Alliance > -------Original Message------- > From: Peter Buchanan <[email protected]> > Subject: Filemaker to flat file/ EDI > Sent: Oct 01 '09 06:06 > > Can anyone offer advice and direction on exporting data from FM10 (I am > thinking in CSV format) and from that output, creating a flat text file > with definite fixed widths for each field. This file is then used for EDI > with other service providers. > > > Is it possible / feasible doing this in FM itself (unused spaces would > have to be filled with blanks) , or can anybody recommend software that > will do this I have heard of translator software? > > > Many thanks > > Peter
