Archives of the TeradataForum

Message Posted: Mon, 02 Jan 2006 @ 10:30:58 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hello All,

I have a CSV file I am trying to load using Multiload. The file has character fields with values such as "Cingular Wireless, Inc" or "XYZ, Inc". Every char field is encased in double quotes.

The problem I am having is MLOAD does not recognize the string as whole and splits the field into two, "Cingular Wireless" and "Inc", becasue of the comma. Result is, the record is not loaded as the data does not match the layout.

How do I get MLOAD to load the contents between 2 quotes into one column, irrespective of whether the field contains comma or not?.

Recreating the file with pipes as separator instead of the comma is not an option.

Thanks,

Raghav Vaidya

	<Prev	Next>		<<First	<Prev	Next>	Last>>