Exporting fixed width data

G

Guest

I am doing a fixed width export from a table and trying to keep the leading
zeros in a field the zeros are in the table but lost after the export
 
K

Ken Snell \(MVP\)

Create a query that is based on the table. In place of the field with the
leading zeroes, use a calculated field with an expression similar to this:

MyFieldToExport: Format([RealFieldName], "0000000000")

In the above example, I've assumed that you want 10 characters in the
exported value. Change the number of zeroes to meet your needs.

Then export this query.
 

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

Keep leading zeros in txt export 2
Export of text field trims leading zeros 1
Exporting a fixed-width file 6
Exporting Text with a variable Number of Leading Zeros 3
How do I keep leading zeros and remove the decimal point when expo 2
Exporting to Excel and then reimporting from Excel 1
validation rule for exactly 5 digits, including leading zeros 0
Left zero fill on export of field 4

Top