Stripping newlines and carriage returns.

[Crin]

Hi,

I have written a script that exports the contents of the products databes and write a tab delimted text file with results. This is used for importing the inform######## in Gemm (www.gemm.com)

This all works fine until the script encounters a listing with carriage returns in the comments at which point this is output to the tab delimited text and is interpreted as a new row.

I have tried to strip these using...

$products_description = str_replace("/n", " ", $products_description);
$products_description = str_replace("/r", " ", $products_description);

before echoing the $products_description into the text file but it doesn't seem to be working.

Does Zencart store carriage returns inputted in the admin interface as something else?

Many Thanks.

Crin

[Chuckl]

No, it stores them as carriage returns. You however are trying to replace something else. Carriage returns and linefeeds are denoted by backslashes? "\r" "\n" would probably be more effective

[Crin]

HA HA HA HA HA HA!

Omg that was stupid. Thanks, sometimes it takes a fresh set of eyes huh!?

[Chuckl]

We all do it all the time. Those are usually the most difficult errors to find, because we don't read what is actually there. We "know" what is there.

Rgds,