Cheers @tyler_durden for the quick response.
I've reviewed what I've been requested to do and figured that I really only need columns $1, $2, and $5 which are all the same length so losing the blank space formatting is okay at this point.

However keeping the space formatting is essential for most requests.

If anyone knows how this can be achieved I would be interested to hear it.

Cheers,
Barry