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