Issue when export a table to CSV file
Posted by:
Jingyu Qi
Date: January 21, 2009 09:59PM
Hi all,
I have a table, in which a particular field may have a string with "\n" char. So when I try to export this table to csv file, the record with this field will be seperated to two lines, not like other records. I am using "\n" as LINES TERMINATED BY. I was trying to use "FIELDS ESCAPED BY '\'", but got errors.
I need find a way to replace the "\n" in the filed to white space.
Thanks,
Jingyu.
Subject
Views
Written By
Posted
Issue when export a table to CSV file
12044
January 21, 2009 09:59PM
6603
January 31, 2009 06:01PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.