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 spreadsheet 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) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
pgp00000.pgp
Description: PGP signature
