Exporting numeric fields with leading zeroes

G

Guest

I am unable to export a query to a fixed format text file with leading
zeroes. The query will display the zeroes, but the export process strips
them off, and outputs the field as fixed length, zero suppressed, left
justified, blank filled on the right.

I need the zero filled field in order to format the output for compatibility
with a legacy application.

Thanx in advance.
 
J

John Nurick

Hi,

The usual way round this is to use the format function in a calculated
field in a query, and then export the query, e.g.

fMyField: Format([MyField], "00000000")

for an 8-character wide field with leading zeroes.
 
G

Guest

Worked Great.
Thanks!

John Nurick said:
Hi,

The usual way round this is to use the format function in a calculated
field in a query, and then export the query, e.g.

fMyField: Format([MyField], "00000000")

for an 8-character wide field with leading zeroes.

I am unable to export a query to a fixed format text file with leading
zeroes. The query will display the zeroes, but the export process strips
them off, and outputs the field as fixed length, zero suppressed, left
justified, blank filled on the right.

I need the zero filled field in order to format the output for compatibility
with a legacy application.

Thanx in advance.
Click to expand...
Click to expand...
 

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 numeric numbers with leading zeroes 2
Export zero-filled fields into a text file 3
How do I keep leading zeros and remove the decimal point when expo 2
Using ToString to pad an integer with leading zeroes 8
leading zeroes being stripped 1
Exporting Leading Zeroes to .txt file 2
Export table to text file with numeric field to have leading zeroe 1
exporting number field with leading zeros 2

Top