Hi!

I want to export a table as text with fixed positions. Field_1 from position 1 to 32 and with blank space filled with zeros. Field_2 from position 33 to 39 and with blank space filled with underscore...and so on. Record line ends with carriage return.

All in all there are 32 fields and 8000 records. The data in every field can vary in length.

My first thought was to create a calculation field collecting all 32 fields with a lot of text functions, but I hope there is a better way.

Thank's in advance!

You'll need either a calculation for each field or an auto-enter calculation applied to each field with 'Do not replace existing value' deselected. The calc for Field_1 would be Right( "00000000000000000000000000000000" & Field_1; 32 ). Field_2 would be Right( "_______" & Field_2; 7 ), etc.