<div>
Gary,<br />
<br />
I did the equilavent of that if php, using str_replace, like this:<br />
<br />
$wc = str_replace('\r', ' ', $wc);<br />
$wc = str_replace('\n', ' ', $wc);<br />
<br />
$wc being the extracted value from the database.<br />
<br />
Has no effect.<br />
<br />
The text was probably entered on an iPad. Does that make a difference?<br />
<br />
Thanks
</div>


Gary,

I did the equilavent of that if php, using str_replace, like this:

$wc = str_replace('\r', ' ', $wc);
$wc = str_replace('\n', ' ', $wc);

$wc being the extracted value from the database.

Has no effect.

The text was probably entered on an iPad. Does that make a difference?

Thanks

<div>
Works in MySQL. I had preferred not to change the database text, but ..............
</div>


Works in MySQL. I had preferred not to change the database text, but ..............

<div>
Ahh you didn't say you wanted to do it in PHP, your zones were just MySQL<br />
It would depend on how the CR's were being interpreted and stored in the DB i.e are they using the HTML tag of &lt;br&gt;
</div>


Ahh you didn't say you wanted to do it in PHP, your zones were just MySQL
It would depend on how the CR's were being interpreted and stored in the DB i.e are they using the HTML tag of <br>

<div>
<div class="content wysiwyg-content">
I have this text in a MySQL database &quot;blob&quot; field:<br />
<br />
&quot;Initially a warranty call but water was shut off and we spent a few days troubleshooting and fixing leaks on old system that had been disconitued.<br />
<br />
When we got everything working we made adjustments on new rotors and rebuilt 1 1/2&quot; valve that was stuck open (warranty)&quot;<br />
<br />
I want to eliminate the cr / lf characters when I extract it into a php program.<br />
<br />
How can I do that?<br />
<br />
Thanks.
</div>
</div>


I have this text in a MySQL database "blob" field:

"Initially a warranty call but water was shut off and we spent a few days troubleshooting and fixing leaks on old system that had been disconitued.

When we got everything working we made adjustments on new rotors and rebuilt 1 1/2" valve that was stuck open (warranty)"

I want to eliminate the cr / lf characters when I extract it into a php program.

How can I do that?

Thanks.

Cr / lf in MySQL text

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.