Re: New line problem - but for Excel
| From: | David T-G | Date: | Sat, 29 Nov 2003 05:03:49 +0000 |
| Subject: | Re: New line problem - but for Excel | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-171326@lists.php.net to get a copy of this message | ||
Manisha --
..and then Manisha Sathe said...
%
% Actually I do not have phpscript for this. I am using readymade function
% from PHPMyAdmin 2.1.0. They are having option to export to csv file with
% delimeter ';' (It comes on screen first and then i copy to file manually.)
Ah.
%
% So my csv fil looks like
%
% 22;33;address line1
% address line2
%
% What excel does is it shows this as 2 different lines. But this all should
% be in one line.
OK. So what does Excel do if you start with data like that and then
export to CSV? Can you have multi-line "records" in Excel? If so, are
they written as such?
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!