Right align text field for export 1

[KARR]

All,

Looking to export a table containing a text column containing data such as 212.59, 11.39, etc. The export will be to a fixed width text file.

I am having an issue getting the field to right align\justify. I took a look at the format command try it do it from a query rather than the table but havent had much luck.

Any hints?

Thanks

 

[PHV]

Say your fixed column length is 11, then you may consider thi expression:
Right(Space(11) & [your field], 11)

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

 

[KARR]

This would go into the query itself under SQL view?

 

[PHV]

under SQL view:
SELECT ..., Right(Space(11) & [your field], 11) As myFixedCol, ...

in the query grid:
myFixedCol: Right(Space(11) & [your field], 11)

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

 

[KARR]

Ah..that did it.

Thanks!