SQL*Loader - 如何忽略具有特定字符的某些行

如果我有一个以下格式的 CSV 文件

"fd!","sdf","dsfds","dsfd"
"fd!","asdf","dsfds","dsfd"
"fd","sdf","rdsfds","dsfd"
"fdd!","sdf","dsfds","fdsfd"
"fd!","sdf","dsfds","dsfd"
"fd","sdf","tdsfds","dsfd"
"fd!","sdf","dsfds","dsfd"

是否可以排除第一列在字符串末尾有感叹号的任何行。 即它应该只加载以下行

"fd","sdf","rdsfds","dsfd"
"fd","sdf","tdsfds","dsfd"

Thanks

根据根据条件加载记录 http://www.comp.dit.ie/btierney/oracle11gdoc/server.111/b28319/ldr_control_file.htm#i1005657SQL*Loader 控制文件参考 (11g) 的部分：

“您可以使用以下命令选择加载或丢弃逻辑记录WHEN子句来测试记录中的条件。”

所以你需要这样的东西：

LOAD DATA ... INSERT INTO TABLE mytable   WHEN mycol1 NOT LIKE '%!' 
(mycol1..  ,mycol2 ..)

But the LIKE运营商不可用！你只有= and !=

也许您可以尝试使用外部表。