Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 20 Aug 2012 @ 20:17:21 GMT


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


Subj:   Separator in Mload
 
From:   Mani, Vijay

Hi,

I am trying to load the below file using Mload utility. I used the separator as |

     19799|"744"|"A "|"Online|
     29799|"744"|"B "|"Online|
     39799|"744"|" "|"Online|
     49799|"744"|"Y "|"Online|

my table is getting loaded with

     19799 "744" "A " "Online?
     29799 "744" "B " "Online?
     39799 "744" " " "Online?
     49799 "744" "Y " "Online?

I need to remove " before loading it into the table. What should I do to remove "


Thanks,

Vijay Mani



     
  <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