Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Separator in Mload
From:   Mani, Vijay


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 "


Vijay Mani

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020