Archives of the TeradataForum
Message Posted: Mon, 02 Jan 2006 @ 10:30:58 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|