antp.be forum

just notices when using export by SQL that its using || for CR+LF
how do i get it to proper do linebreaks so that when its imported into sql table it will be correctly formatted.

ta

How should linebreaks appear? With \n? You could do a search/replace with a text editor.

sorted this one out now.. it was the Description and Comment fields i was talking about that Export with || for linebreaks.

Ideally i would have expected the SQL CSV file to contan \n as in PHP you can do.

$description=nl2br($description);

but instead i did a search/replace in php with

$html_tag = '<br />';
$description = str_replace('|', $html_tag, $description );

so all good now thanks.

You are right, it would be more logical for SQL export to use \n...
Well, there are lots of things to improve

hehe... well its a very good program

Now i know the work around its easier enough to do