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 <
[hidden email]>
> 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
