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 do i export line breaks in SQL export
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.
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.
Last edited by kazgor on 2006-06-04 16:44:02, edited 1 time in total.
