Peter,
It may be old school, but I use a calculation field to build my export record. I can pad spaces or leading/trialilng zeroes as needed to make each field the desired length. Then, I export only the calculation field in a tab delimited format. Steve Lemond Univ of Tennessee Martin 731-881-7895 From: FileMaker Pro Discussions [mailto:[email protected]] On Behalf Of Peter Buchanan Sent: Thursday, October 01, 2009 9:06 AM To: [email protected] Subject: Filemaker to flat file/ EDI 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
