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
