Keep leading zeros in txt export

J

JT9090

We have a table that gets updated and the results are exported to a
fixed-width text file (and then uploaded to an external company).

The table has an autonumber field with format set to 000000000. When we
view the table, this gives us the proper 9-digit number requested by the
external company (ie 000002342), however we've discovered that when we export
the table to a fixed-width txt file, the autonumber field loses its leading
zeros.

How do we maintain these leading zeros? Thanks.
 

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

Export of text field trims leading zeros 1
Droping Leading Zeros In Table 2
Exporting Text with a variable Number of Leading Zeros 3
Leading Zeros 6
How do I keep leading zeros and remove the decimal point when expo 2
Adding in leading zeros and a space to a text field in a table 4
Exporting fixed width data 1
Leading Zeros 1

Top