Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 24 Jan 2003 @ 20:54:43 GMT


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


Subj:   Mload and doble quotes in a comma delimited file
 
From:   Srikanth Uppaluru

Hi

Does any one have idea on loading a data file with variable record lenght. The file is a comma delimted file and each field is packed in double quotes ie.,' " '. I cmae across a situation wherein some of the values in one of the fields are having comma inside the value and multilaod sees that as a separate field.

Is there any way to avoid such situation wiithout causing multiload to fail or reject the records as it thinks that the particular reocrd/field is larger than specified length.

Any suggestions or ideas are much appreciated.

Thanks for help in advance.

Srikanth Uppaluru



     
  <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