padding with spaces

[fusiongirl]

I need to write data to a fixed length file. So if I have a field that is 10 characters long but the file has room for 15 spaces I want to pad it with spaces. Can someone tell me the best way to accomplish this?

[Guest]

myString & repeatString(" ", 15-len(myString))

[MikerRoo]

Actually that's not a good solution.

The best way to do this is to pad the values, in the source query, using DB functions.

The next best way is to use the LJustify() or RJustify() Coldfusion functions.

[fusiongirl]

Thank you.

[Guest]

interesting. i wasn't familiar with the LJustify() or RJustify() functions. nice 🙂