Text Export Formatting

[Mantle51]

Hello,
I have been given the task of exporting a table to a fixed width .txt file. I have set up the export specs as well as configured individual field parameters in table design however, 2 things are not reconciling:

1. I need to display a value with no decimal, hence 23.568 will appear
23568 in output. (The export spec does not allow for empty argumentin the decimal paramter).

2. The tables will not show trailing zeros even though fields are set to a specified decimal length. This, in turn, is translated to the .txt file

Many thanks for your considerations

 

[Remou]

You need to work with a query, rather than a table. That way, you will be able to use Format and other functions to get the output you want.