Archives of the TeradataForum

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

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

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>>