Re: sqlldr question.

Hi Jan,

you are right. You can only specify one termination char or whitespace.

I had a similar problem. I loaded my data into an auxiliary table, terminated by whitespace. I used only varchar2 columns for this auxiliary table. I offered as many columns as would be needed for the maximum number of fields in the input data. Then I used some batch sql for correcting the assignments of strings to my criteria.

Regards,

Martin

Jan Eliasen wrote:
>
> Hi there.
>
> I have a datafile with lines like this;
> 0080 A. C. Jacobsens Vej 5 34 9400 Norresundby
>
> 0080 is one field.
> "A. C. Jacobsens Vej" is the second field.
> The rest are one field a piece.
>
> I have the following control file;
> LOAD DATA
> INFILE 'RoadNames.dat'
> REPLACE
> INTO TABLE RoadNamesTemp
> (Road_Code TERMINATED BY WHITESPACE,
> Road_Name TERMINATED BY [0-9],
> LowHouseNo TERMINATED BY WHITESPACE,
> HighHouseNo TERMINATED BY WHITESPACE,
> Postal_Code TERMINATED BY WHITESPACE,
> Postal_District TERMINATED BY WHITESPACE)
>
> It does not work. The problem being of course the [0-9] thingy. What do I
> do instead? I want the field to be terminated by a number - any number. I
> can't find anything in the documentation. Can it really be so that you can
> only terminate by a string, whitespace or a single character?
>
> Please help.
>
> --
> Eliasen Jr.
Received on Fri Dec 21 2001 - 07:35:23 CST