List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 28 2002 4:04am
Subject:Re: Multiple Field Terminators in LOAD??
View as plain text  
At 22:35 -0800 1/27/02, Chris Williams wrote:
>I'm trying to create a LOAD statement that will enable me to load both a
>comma or tab delimited text file. I am only successful in achieving one or
>the other by using:
>  "LOAD DATA LOCAL INFILE mfile.txt INTO TABLE Temp FIELDS TERMINATED BY
>'\\t,' LINES TERMINATED BY '\\r\\n'
>or
>"LOAD DATA LOCAL INFILE mfile.txt INTO TABLE Temp FIELDS TERMINATED BY ','
>LINES TERMINATED BY '\\r\\n'
>
>I don't know however the proper syntax to include both field termination
>parameters in one LOAD statement

You can't.

>  like I am able to do with line termination.

You can't do that either.  Your statements don't describe a termination
string that's one or the other, they describe a termination string that
requires both.

>
>Regards,
>Chris Williams

Thread
Multiple Field Terminators in LOAD??Chris Williams28 Jan
  • Re: Multiple Field Terminators in LOAD??Paul DuBois28 Jan