Exporting data to a fixed width text file

J

John

Hi,

I'm trying to export data to a fixed width text file, but I want all the
numeric fields to be exported right justified instead of left justified which
is what is happening at the moment. Can anybody help?

John
 
K

Ken Snell [MVP]

Use an expression similar to this as the calculated field for a numeric
output (this example assumes that the fixed width of the numeric field is 10
spaces):

MyOutput: Right(Space(10) & [NumberFieldName], 10)
 
Top