Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 24 Jan 2003 @ 22:43:17 GMT


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


Subj:   Re: Mload and doble quotes in a comma delimited file
 
From:   Jason Fortenberry

If you have commas within your fields, you have to use a different delimiter. Can you re-export the data with a different delimiter, such as pipe "|"? If not, I could share with you a Perl script that will update the comma delimiters only in your text file to another delimiter.

You will also have to remove the double quotes from your files so that they are not loaded as part of your fields.

--Jason



     
  <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: 15 Jun 2023