Export table - numeric fields with leading zero's

[AT76]

Hi,

I'm exporting a table to a text file. I'm exporting it with fixed widths. Some of the fields are of type number. I need to add leading zeroes to these fields. Does anyone know how to do this?

Thank you in advance!

 

[PHV]

Export a query (playing with the Format function) instead of the table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[AT76]

Thank you PHV...

That worked... but now when I export the table to a TXT table it still removes the leading zeroes? I'm doing a fixed field length format. Any ideas?

Thank you!

 

[Remou]

I have tried
[tt]Format([intInteger],"000000")[/tt]
in a query and it seems to work as an export.

 

[AT76]

I used FORMAT([field name)], "00000") and it did work as far as placing the leading zeroes. But when I export it to a text file using a specified field length it removes the zeroes. Any thoughts?

 

[Remou]

This is not what I found. I chose export, txt, fixed width and found that I was loosing the numbers to the right. However, if I then chose Advanced and increased the size of the field, the numbers exported with the leading zeros. When another field followed the formatted field it was necessary to increase the start position by one.

 

[AT76]

I guess another question to try and avoid this is can I export this table directly to the AS400?

Thanks!

 

[Remou]

These two random links seem to imply that you can:

http://faq.midrange.com/data/cache/318.html

http://www.geocities.com/Hollywood/Lot/8476/AS400/#4.1

 

[AT76]

Very cool Remou!

Here's a link that solves the leading zero issue when exporting table to a fixed field.

http://groups.google.com/group/micr...h+leading+zeros&rnum=3&hl=en#03141cfbbfe3f8ae

Thanks!