Comments in SQL Loader, CSV file -

i generating csv file read database using sqlldr , wondering if there compatible comments can put in file?

# using comments of format # , want add information file came 

however, sqlldr reports these rows not loaded due data errors, confusing user attempting debug import process.

i have taken @ sqlldr documentation , not mention comments. answer this question outlines csv files not have comments of own standard, standard defined application reading file (in case sqlldr).

is there compatible comment type can used sqlldr?

i don't believe sqlldr allows comments in data per-say, may able around specifying with clause in control file loads rows first character not equal '#'. note '#' have in same position, not anywhere on line.

edit: tried , works charm.

data file:

# comment in data file 1|\a\ab\|do not "clean" needles|@ # comment in data file 2|\b\bg\|wall "69" side end|@ # comment in data file 

control file:

load data infile 'x_test.dat' table x_test when (1:1) <> '#' fields terminated "|" optionally enclosed '"' trailing nullcols (   col1,   col2,   col3 )