I have a report with multiple fields on it. Each field is required to be a specified width upon export, whether it is text or numeric. All numeric fields are to have leading zeros to fill in the required field size of 9. All numeric fields must be multiplied by 100 so there are no decimals, nor may there be any commas. The final file is 256 characters wide, and is to be formatted, space delimited. That eliminates Excel as an in-between manipulator; it only goes to 240 characters. How do I get the text output to be an exact number of characters? How do I get the numeric output to be exactly 9 characters wide with leading zeros?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.