If I understand your question correctly: If you are on Unix, or have the sed utility available. then you can do something like the following. Assume X is the character to eliminate.
sed 's/X//g' < CSV_file > temp_file verify temp_file is OK, then replace CSV_file with temp_file. Perl has syntax similar to this. > -----Original Message----- > From: oraora oraora [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 23, 2002 11:49 PM > To: Multiple recipients of list ORACLE-L > Subject: Migrate table data to CSV file - Urgent help !!! > > > Guys, > > i want to export table data into a CSV file. > i am using the script below to do the same. > ---------------------------------------------------------- > set wrap off > set linesize 2000 > set feedback off > set pagesize 0 > set verify off > set termout off > > spool ytmpy.sql > > prompt prompt LOAD DATA > prompt prompt INFILE * > prompt prompt INTO TABLE &1 > prompt prompt REPLACE > prompt prompt FIELDS TERMINATED BY ',' > prompt prompt ( > select 'prompt ' || decode(column_id,1,'',',') || lower(column_name) > from user_tab_columns > where table_name = upper('&1') > order by column_id > / > prompt prompt ) > prompt prompt BEGINDATA > > prompt select > select lower(column_name)||'||chr(44)||' > from user_tab_columns > where table_name = upper('&1') and > column_id != (select max(column_id) from user_tab_columns where > table_name = upper('&1')) > order by column_id > / > select lower(column_name) > from user_tab_columns > where table_name = upper('&1') and > column_id = (select max(column_id) from user_tab_columns where > table_name = upper('&1')) > order by column_id > / > prompt from &1 > prompt / > > spool off > > set termout on > > @ytmpy.sql > exit > ----------------------------------------------------------------- > things work fine. > for example , i have a record as below (fields seperated by , ) : > AAA,BBBBB,CCCCC,DDDDDEEEE ,FFFF,GGG > the at the end of DDDDDEEEE is new line character .....hope so. > when this record gets written to CSV file , it is like this : > AAA,BBBBB,CCCCC,DDDDDEEEE > you can see the data after is truncated. > and the records after this without are written properly. > problem occurs when there is in a record. > how to get rid of this ? > > kindly help me plzzz. This is quite urgent. > > TIA. > Jp. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: oraora oraora > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
