Hi,

I would like to know if there is any way to load csv files with mload when they contain quotations. Excel places quotations marks around cells that have "" commas as cell value.

I know in Oracle there is and Optional tag in the control file to indicate data file may also be enclosed in double quotes. Is there such a think for Teradata Mload?

I am aware of the option to save the file as Tab Delimited and then replace Tabs with "" but was hoping for a better solution than this.

Thanks,