Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Formats with Multiload
 
From:   Raghav Vaidya

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016