Exporting data to a fixed width text file

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
Exporting Fixed Width Overlapping Fields 1
How do I Export Text field right justified and zero filed? 1
fixed width field for export 1

Back
Top