Fixed Length Fields 1

[ewilkes]

I have a crystal report that I need to export in a fixed-length ascii format. I need to make the field length, for example, 30 characters regardless of the data in it. How can I do this? I've used "left" to limit the field to 30 char's but that only helps if the length of the text exceeds 30 char's. How can I make it 30 even if the text is, say, 10 char's. Thank you

 

[dgillz]

I am assuming you want to put a space for the rest of the characters. If so the following formula should work:

If Length({YourString})>= 30 then left({YourString},30) else trim({YourString})&Replicatestring(" ",30-length(trim({YourString})))



Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[ewilkes]

Worked perfectly! Thank you