stevefromOZ (11/21/2014)
Quick response - I would go with a scripting approach like this[/url]. Does this suck? Yes.Longer response - the definition of ragged right is that all columns are fixed width except the last column. This is *not* the format you have, You have a fixed width file of differing widths.
Some other choices:
- add a delimiter to your file (e.g. pipe or comma), remembering to have delimiters even when the field is empty.
- add spaces to your file (leaving it fixed width) so that every column exists, even if it's "empty" (all spaces). You'd then have to manage that data (the spaces piece).
Cheers for the quick reply, you're right - my interpretation of ragged right isn't right (jeez, there's too many 'rights' in this sentence already!)
I like the idea of tacking on a number of spaces so every row is the same length.... nice one 🙂
Thanks again!