Exporting numeric fields with leading zeroes

[p.armstrong]

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.

 

[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.

 

[p.armstrong]

Worked Great.
Thanks!

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.