Re: SQL*Loader Question

Terry Ball wrote:

> One of our programmers asked me a question about SQL*Loader which I
> could not
> answer. I am hoping someone out there can help.
>
> Basically the problem is this. He has a field which can be as much as
> 25 characters in
> length. However, most of the time it will only have ten characters. He
> wants to
> eliminate the trainling blanks. Sounds easy. But the problems is,
> sometimes there may
> be blanks imbedded in the data. So the data coule look something like
> 'dir 453 7'. It
> would come over in a file looking lik 'dir 453 7 '. He
> wants to preserve the
> impedded blanks but eliminate the trailing blanks. We will be using
> direct load, so the
> rtrim function is not an option.
>
> Is there a way to do this?
>
> We are using Oracle 7.3.3.5 on an IBM SP2 with AIX 4.1 and 4.2.
>
> TIA.
>
> Terry Ball
> DBA
> CSG Systems, Inc.
> terry_ball_at_csgsystems.com

Please disregard the above. The programmer just called me. He had copied a load script for another table which had preserve blanks as part of the header. So of course loader was preserving the blanks.

Thanks anyway.

Terry Ball
DBA
CSG Systems, Inc.
terry_ball_at_csgsystems.com Received on Wed May 27 1998 - 18:29:54 CEST