New line problem - but for Excel
From: Manisha Sathe (manisha_at_starhub.net.sg)
Date: 11/29/03
- Next message: David T-G: "Re: [PHP] New line problem - but for Excel"
- Previous message: junt_tuko: "PHP - Apache Configuration"
- Next in thread: David T-G: "Re: [PHP] New line problem - but for Excel"
- Reply: David T-G: "Re: [PHP] New line problem - but for Excel"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
To: php-general@lists.php.net Date: Sat, 29 Nov 2003 12:29:04 +0800
Just now discussion was going on for new line - the same worked for me (I
used string replace)
Live Server : Linux / MySQL / PHP
There is a field called 'Address' (textarea) - mysql stores \n for carriage
return. Now from current disussion thread i know i can remove this with
something like <br> (may be something else also)
I want to export this to csv file. PHPMyAdmin 2.0 version has one option to
convert to csv with delimiter e.g ';' .
On my computer (Windows)
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.
Is there any better way so that '\n' does not come out as new row - but do
not want to make use of <br> as this will appear, please suggest,
regards
manisha
When i open it in Excel now that \n becoms a new row which i do not want
- Next message: David T-G: "Re: [PHP] New line problem - but for Excel"
- Previous message: junt_tuko: "PHP - Apache Configuration"
- Next in thread: David T-G: "Re: [PHP] New line problem - but for Excel"
- Reply: David T-G: "Re: [PHP] New line problem - but for Excel"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
