Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 15 Apr 2005 @ 14:55:44 GMT

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

Subj:   Re: Fastloading delimited file
From:   Prescott, Kyle R

You can use MLOAD and do the following in the values clause of the insert DML statement to strip the double quotes.

You may want to delimit the data other characters then commas with this type of data. PIPE (|) or TAB work well.

FastLoad doesn't allow manipulations of the data like this, but MLOAD does ...

     ,Trim(BOTH '"' FROM :FIELD1)
     ,Trim(BOTH '"' FROM :FIELD2)
     ,Trim(BOTH '"' FROM :FIELD3)
     ,Trim(BOTH '"' FROM :FIELD4)
     ,Trim(BOTH '"' FROM :FIELD5)
     ,Trim(BOTH '"' FROM :FIELD6)
     ,Trim(BOTH '"' FROM :SUR_FULL_NAME)

Kyle Prescott
UnumProvident, Data Strategies

  <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