Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 29 May 2003 @ 20:15:49 GMT


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


Subj:   Re: Multi load -- Data file with spaces
 
From:   Dieter Nöth

Sada Shirol wrote:

  I am in a process of loading data into teradata using multiload. My data file has space characters with in the delimiter. Is there an option in multi load commands (either in layout or import) to ignore spaces. I am able to load data without spaces with no problems.  



I'm not shure what you mean:

If you have fixed length data you can use

.field foo * char(20) drop trailing blanks;


to trim blanks. This casts foo to a Varchar(20).

If you have white spaces between data columns you can specify them as

.filler char(1);


Dieter



     
  <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