Fixed text field export with character spacing 2

[socalvelo]

CR2011
SQL db

I need to export a text field for use in a CSV file that is fed into another databae. It needs to be 38 characters. Easy enough using left({Permit_Main.DESCRIPTION},38)

However I need to fill in with character spaces if the field has less than 38 text characters.

Can someone help with a formula that will give me 38 characters and spaces with or without 38 text characters. The spaces would fill the gap to the next field in my CSV file.

 

[Charliy]

LEFT({TABLE.FIELD}+SPACE(38),38)

 

[CoSpringsGuy]

nice one Charliy
I usually use {TABLE.FIELD}& space(38-len({TABLE.FIELD}) but I will use yours from now on

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

 

[socalvelo]

Thank you for the help. It works great.

 

[CoSpringsGuy]

Be sure and click the star for Charliy for Great Post... That way others will know this question has been resolved.

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

 

[SkipVought]

BTW ...

Comma
Separated
Values

...is what CSV means.

So your file is Fixed Width, not CSV, probably needed as input for a COBOL program or the like, to a mainframe system.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[socalvelo]

Skip,

Thanks for clarifying that for me. I erroneously was using CSV as a general term.
My export indeed needs to be just a text file full character spacing only.

 

[Charliy]

I have to do a lot of fixed length files so I set that up as a User Defined Function. Now I can just say
EXACTLY({table.field},38)
and it gives me that same result.