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?