Exporting Text 1

[duquesne]

I am trying to export fixed width text. I need one of the fields to be right justified...ugh! However, I can not figure out how to right justify if it is type "text" and I can't export to fixed width if all fields aren't in "text" format. Any ideas??

 

[BNPMike]

I can't just see how you can directly right justify - seems an odd ommission. Any way you can do it your self. You want to create a new field which has your data on the right.

The basic steps are

Trim the data to remove blanks. TRIM
Get the length LEN
You'll need a variable or literal that is all blanks. Calculate what left portion ie number of blanks you need from this and concatenate this onto the front of the trimmed data. Your data now gets pushed to the right boundary. For field size 20:

Something like
LEFT(blankfield,(20-LEN(TRIM(field)))) & TRIM(field)

 

[tlbroadbent]

Use the RIGHT and SPACE functions as follows to Right justify text. The example will right justify a 50 character column. Adjust as needed.

Right(Space(50) & [ColName],50) Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.