- 论坛徽章:
- 0
|
环境:oracle10g + Win2003
需要导入的数据是csv格式数据(逗号分割,双引号括住的)
本来正常,可是有一天多出一条数据,具然有一条数据的一个列中多出一个双引号,导致这条数据被丢掉。
如下格式:
”a"."11111","bbbbb","cccccc",""ddddd","mmmmm"
由于数据是外部提供,还不能修改,所以请问控制文件如何修改能导进去??
当前的数据文件是
load data
TRUNCATE
PRESERVE BLANKS
INTO TABLE table_aaa
--FIELDS TERMINATED BY ',' Optionally enclosed by """
(
filed1 CHAR(6) TERMINATED BY ',' Optionally enclosed by '"',
filed2 CHAR(12) TERMINATED BY ',' Optionally enclosed by '"',
filed3 CHAR(1) TERMINATED BY ',' Optionally enclosed by '"',
filed4 CHAR(60) TERMINATED BY ',' Optionally enclosed by '"',
filed5 CHAR(12) TERMINATED BY ',' Optionally enclosed by '"',
filed6 CHAR(20) TERMINATED BY WHITESPACE Optionally enclosed by '"' ) |
|