Newline Problem with Generating Excel Spreadsheets

dp777

Hello. Ok, I have a script written that pulls data from mysql database and shoves it into an excel spread sheet. The spread sheet is working great and all information is there. However, the problem I have is that in the database there are a couple of text fields with data entered in them as:
blahblahblah
/n(?not sure if this is a newline or not...)
blahblah line two

and when this is pulled into the spread sheet is is inserting the first line (blahblahblah) into the approiate column, however when it hits the newline it moves the rest of the spread sheet down a row so that blahblah line two is now in the wrong row and is in the first column. Any ideas? So far i've tried running it through chop(), rtrim(), str_replace() on the newline (which is leading me to believe that it is not a newline since i've also tried running it through nl2br and then put it through strip_tags()). Any help would be greatly appreciated!!! Thanks in advance!

laserlight

if possible view the data through a hex editor.

Is the new line sequence \r, \n, or \r\n ?
Which is the new line sequence for the spreadsheet?

Then you can determine how to say, str_replace() the new line sequence.

dp777

laserlight -- thanks for the help! I'm an idiot, i was trying /n/r not /r/n! duh! the /r/n worked great! Thanks!

ultiphp

I have a form in a PHP page that allows a user to enter some text. I then store the text in MySQL. The data in the MySQL table is linked to an Excel spreadsheet through ODBC. When I view the text in Excel, the newline displays as a binary character - an outline of a box (rectangle). I can strip the newline, but I imagine the user wants it there, but it keeps displaying that box and that is not acceptable.

Anyone else see this or have ideas?

Much thanks,
Jonathan