I am building an output file that has to be formatted to have the fields in a specific set of columns. For example, the field for the company ID is designated as Text(80) to be placed in position 3-82 of the file row, but the actual company ID is only 20 characters. I need to pad the end of the name with spaces, so, for example:
"MyCompany"
becomes
"MyCompany " (with the correct number of spaces)
There are also numeric fields that need to be specific lengths, so a number of 123 has to be formatted to 000123.
I couldn't find such a function in Kapow. There are trim and collapse functions, but no padding that I see.
Does anyone have a good solution for this?
Thanks much.
"MyCompany"
becomes
"MyCompany " (with the correct number of spaces)
There are also numeric fields that need to be specific lengths, so a number of 123 has to be formatted to 000123.
I couldn't find such a function in Kapow. There are trim and collapse functions, but no padding that I see.
Does anyone have a good solution for this?
Thanks much.