Archives of the TeradataForum

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

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

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