Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 02 Nov 2009 @ 13:46:14 GMT


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


Subj:   Re: Escape character for MLoad
 
From:   Ferry, Craig

Thanks Victor. No my two issues are two separate things. The reason I need to figure out an escape character is that I have feeds from a different system which automatically uses a \ as an escape character. So when it is outputting data, if it finds a pipe (|) in the middle of a field, it inserts a \. Obviously it does the same thing if it finds a \, it just makes it \\. I know I can write a sed program to do the replace, but just thought it would be easier if there were an escape functionality in the mload program itself. I looked through the mload manual and searched the knowledge base on the Teradata site, but couldn't find one.



     
  <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