load field from database to csv

[nagasea]

Hi i'm trying to pull a field from database and then format it to single line csv for each row.
the problem is I had "carriage return (enter)" on the field and that makes the csv looks weird...

it's suppose to be like this :

1,Hey this is test file,500
1,Hey this is test number two,500

instead of

1,Hey this is
test file, 500
2,Hey this is
test number two,500

---

ID TEXT VALUE

1 Hey this is 500

test file

2 Hey this is 500

test number two

[nunomira]

hi,

why don't you remove the carriage return?

$text = str_replace ("\r\n", " ", $text);

[nagasea]

okay that's works too.
but my question if I still want to keep the return in the csv how to do that ?. so I want to keep that carriage return in the csv what should i do ?

thanks

[nunomira]

this?:

$text = str_replace ("\r\n", "\\\\r\\\\n", $text);