Exporting Data to Create a Fixed Length Flat File

[ShaneWright]

I am using Filemaker 6.0 and need to export Order Data, Name, Address, City, State & Zip to create a fixed length flat file. The file I need to create must be 168 characters in length. I am importing orders from our website into filemaker and need to transfer them to our AS400 system. We have another system that reads order cards and creates an ALT.OUT file with the data. I need to duplicate this file to transfer the data. How do I format the file with fixed spaces?

Shane

[jfmcel]

Sounds like you need one calculated field that places the data in the expected character columns. You can then just export all the records from the single field.