How to remove line breaks and put it in excel [message #675962] |
Thu, 02 May 2019 04:37 |
|
ssyr
Messages: 65 Registered: January 2017
|
Member |
|
|
Hi all,
Could you please help me to resolve my below issue.
I am getting line break in column data so I have used regexp_replace function as given below.
When I ran this sql developer it runs properly. But when I have created .csv file .In that file some data is going to other column .Can anyone helps me how can I resolve this issue.
my Query:
select regexp_replace(replace('Jaybird Freedom /
Freedom 2 CHARGING CLIP / BATTERY PACK - Blaze','"','""'),'[[:space:]]+', chr(32))as Samaple_1,
from dual;
Oracle11g
|
|
|
|
|
|
|
|
|