control M (^M) characters in text

[GeckoNZ]

I am extracting data from an MSSQL database and output to a pipe (|) delimited text file. However, I am getting "^M"
characters in my output file. I believe that this is because there must be carriage returns in on of the database fields.

How can I remove them? I have tried the strtr() function but am not sure how to correctly define the control character (^M) for replacement.

 

[GeckoNZ]

Found the answer ...
You can replace the carriage returns as follows :

$text = str_replace(chr(13),' ',$text)