how to 'terminate' the character data to remove ""?

[zhif]

I tried to load data into MySQL

The command I used is as below,

load data local infile 'c:/tmp_0124/COL_LIQ_RPT.del ' into table COL_LIQ_RPT fields terminated by ';' lines terminated by '\n'

In this command, it just describe how to seperate the field and the lines.

Now, I have a flat data, which character values are in ""

In MySQL load commad, could I add something to remove those "" when loading data into MySQL?

Thanks,
zhif