Hi Paul,
I apologize for not being very clear. Its probably my mind thinking and talking in the mainframe language. I will try to be clearer this time.

When a listing is created in the mainframe, position 1 in every line of the report is reserve for carriage returns. This is how the mainframe communicate to the printers for line spacing. Each line in the document actually starts at position 2. So when you FTP the report out of the mainframe into a text file you will see all the carriage returns in position 1. A “1” is a page break a “0” is skip 2 lines a “-“ is skip 3 lines a blank is print next line. All I wanted to do is to strip these carriage return after I'm done using it in my macro and replace them with a blank so I don’t mess up the alignment of each line and the document looks right.

I attached a sample of the document xyz.docx so it will be a little bit clearer. The document consist of hundreds of pages and I only attched 1 page out of this document. I already ran my macro for this document that perform the page break and the skipping of lines. If you look at this sample page, in position 1 of each line you will still see the l the carriage return codes(except for blank, it just mean next line) which I used to do the page breaks and line skipping.

Thank you again for looking at my post and being so patient.
Phil

Attached Files

xyz.docx (13.8 KB, 15 views)