List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 4 2001 8:15pm
Subject:Re: LOAD DATA INFILE Question
View as plain text  
At 12:45 PM -0700 9/4/01, Curtis Spencer wrote:
>I have a text file with around 25 fields but I only want 5 of them.
>They are not the first 5 fields that I want.  Is there a way to skip
>fields using LOAD DATA INFILE so I don't have to build a 25 field table
>and then cut it down? 
>
>Thanks,
>Curtis

No.  You can write a short program that strips out the extraneous
columns.  Or, depending on what platform you're using and the format
of your data, you may be able to use a standard utility (such as "cut"
on Unix).  What kind of machine are you using?

-- 
Paul DuBois, paul@stripped
Thread
LOAD DATA INFILE QuestionCurtis Spencer4 Sep
  • Re: LOAD DATA INFILE QuestionPhilip Mak4 Sep
  • Re: LOAD DATA INFILE QuestionPaul DuBois4 Sep