New line Within CSV
 

Hi guys,

I am pulling some results from an Oracle database and converting to a CSV to
present to a customer. Within one column I have several results seperated by
<BR. This would be a new line within the cell but obviously is not working.
Does anybody know of a character that I can replace this <BR with that will
make each record within that cell appear on a new line when opened in Excel?

Thanks,

Mark League

New line Within CSV
 

It should be <CR for carriage return. You should be writing a line to add
the new line character.

"Mark League" wrote:

Hi guys,

I am pulling some results from an Oracle database and converting to a CSV to
present to a customer. Within one column I have several results seperated by
<BR. This would be a new line within the cell but obviously is not working.
Does anybody know of a character that I can replace this <BR with that will
make each record within that cell appear on a new line when opened in Excel?

Thanks,

Mark League

New line Within CSV
 

Edit/ Replace
Find what: <BR
Replace with : Control-J
--
David Biddulph

"Mark League" <Mark wrote in message
...
Hi guys,

I am pulling some results from an Oracle database and converting to a CSV
to
present to a customer. Within one column I have several results seperated
by
<BR. This would be a new line within the cell but obviously is not
working.
Does anybody know of a character that I can replace this <BR with that
will
make each record within that cell appear on a new line when opened in
Excel?

Thanks,

Mark League