Re: [PHP] New line problem - but for Excel

From: David T-G (davidtg-php_at_justpickone.org)
Date: 11/29/03 

Date: Fri, 28 Nov 2003 23:39:04 -0500
To: PHP General list <php-general@lists.php.net>

Manisha --

...and then Manisha Sathe said...
%
% Just now discussion was going on for new line - the same worked for me (I
% used string replace)

It worked for me, too, once I got the grammar right. Must have been a
typo the first time I tried an array.

%
% Live Server : Linux / MySQL / PHP
%
% There is a field called 'Address' (textarea) - mysql stores \n for carriage
...
% convert to csv with delimiter e.g ';' .
...
% If I do not use string replace command then '\n' goes as a new row. If i
% replace it with <br> then it appears in the Excel that is also I do not
% want.

Good question.

The first thing I would try is embedding a return in a spread*** file
and then exporting that as CSV and see how Excel writes it, and then as a
close second read it back in and see if Excel can read it. Once you know
the format you can work to output the same thing from your php script.

HTH & HAND

:-D 

-- 
David T-G                      * There is too much animal courage in 
(play) davidtg@justpickone.org * society and not sufficient moral courage.
(work) davidtgwork@justpickone.org  -- Mary Baker Eddy, "Science and Health"
http://justpickone.org/davidtg/      Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

Quantcast