Hidden new line markers?
| From: | Jeff Lewis | Date: | Mon, 24 Mar 2003 19:56:34 +0000 |
| Subject: | Hidden new line markers? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-140881@lists.php.net to get a copy of this message | ||
I am using a SELECT statement to grab all items from a database table and while looping through the
results I am connecting the fields with tabs and adding a new line at the end of the row to create a
tab delimited file.
On one field I do a nl2br in order to preserve the spacing in the field. However, when I import it
into Excel, it keeps treating the <br /> as a nl. Am I missing something? I tried removing \r
and \n with str_replace and I have used trim but it still doesn't work how I'm expecting
it to.
Does anyone have any ideas on this?
Jeff