mysql -> excel

[danielle]

I'm migrating a mysql table into an excel spreadsheet using headers.

The problem I'm having is that there are newline characters in some of the fields in the original table that are triggering a new row going into excel.

Any ideas? I've been working too much and am running out of steam. 😕

[nnichols]

you could using nl2br

[danielle]

I tried that with no luck. It inserted a <br /> which excel simply displayed to the screen and still went to a new line.

The manual says "Inserts HTML line breaks before all newlines
in a string" so I imagine the /n is still in there.

I ended up doing this:
$array[field] = ereg_replace("(\r\n|\n|\r)", " ", $array[field]);

I was trying to avoid doing something to each field as there are so many - I'm lazy. But it works well enough.

Thanks

[jenni]

I wanted to re-open this with an additional question. Is it possible to change new lines into a soft return when you export to excel?

Like this:

My Info

• list item 1
• list item 2
• list item 3
  ------------------------

Leaving it with the <br> tags produces this:

My Info

• list item 1
  ------------------------
• list item 2
  ------------------------
• list item 3
  ------------------------

Removing the <br> tags or replacing them with a new line produces this:

My Info

• list item 1- list item 2- list item 3
  ------------------------

In other words, I want new lines to show up in the same field in excel without it making a new row. Any thoughts?

[lights_out]

i guess the <pre> tag would work.