VBS Script to remove carriage returns from large file.

Are you certain the target file has CRLF as its line endings? Perhaps the file only uses LF, at which point your Replace call would not find anything.

Here is an example of the original code and notice that it only has one extra carriage return.

2.80;176;4.93;01/20/2012
;
00904-5125-59
;


In my file it is all together in a text file and where the 59; is there is actually a carriage return between the 9 and the semicolon but here is shows different but that is what I need to remove.

Try altering line 9 to:

strNewText = Replace(Replace(strText, chr(013), ""), chr(010), "")   ' chr(010) = line feed chr(013) = carriage return 

Select all Open in new window

Tried it but didn't seem to work. I would like to send the original file to you but it is business confidential. Is there anyway I can get the file to you without anyone seeing it?

Thanks,
Don

It was a great catch in the code and he fixed it first try.

Thanks again,
Don