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

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

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

Rate Topic

Display Mode

Topic Options

Author

Message

amonadi@hotmail.com

Posted 10/21/2009 5:54:35 PM

Forum Newbie

Group: Forum Members
Last Login: 10/21/2009 5:36:35 PM
Posts: 1, Visits: 1

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,

Post #17130

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 5:06pm