mload upload of csv file with Comma ',' and ""

Tools & Utilities

mload upload of csv file with Comma ',' and ""

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,
3 REPLIES
Enthusiast

Re: mload upload of csv file with Comma ',' and ""

Hello amonadi, Did you get a reply ? I am facing the exact same situation. Comments anyone on the best approach in this situation ? Thanks.
Teradata Employee

Re: mload upload of csv file with Comma ',' and ""

Consider using Teradata OLE DB Access Module with Mload.
Enthusiast

Re: mload upload of csv file with Comma ',' and ""

First load data with '' and "" into db then strip off the single quotes and double quotes.