Exporting data to a fixed width text file

G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting to ascii file 4
Fixed Width - No delimiters - ASCII Text File 7
Exporting Fixed Width Text 3
help with formatting and exporting data 1
Fixed Format Text Export 2
MS Access - Format in Export 3
Exporting Fixed Width Overlapping Fields 1
Text columns exporting to currency columns 5

Top