Re: [sqlite] How do you load a ".csv" and skip the first line?

2012-09-11 Thread John Gillespie
I use "SQLite Manager " extension for Firefox. Don't know if it is available for IE, didn't find it for Safari. John G On 4 September 2012 21:23, Peter Haworth wrote: > Take a look at my SQLiteAdmin tool. It will import csv files with or > without headers, export them that

Re: [sqlite] How do you load a ".csv" and skip the first line?

2012-09-04 Thread Peter Haworth
Take a look at my SQLiteAdmin tool. It will import csv files with or without headers, export them that way too, plus many features to help create and maintain your schema and browse/edit your data. Avaialble at www.lcsql.com. Pete lcSQL Software On Sun, Sep 2, 2012 at

Re: [sqlite] How do you load a ".csv" and skip the first line?

2012-09-03 Thread danap
> Is there some way to load a ".csv" file into a SQLite database table > when the first row (record) of the file contains headers? > > This does not work? > -- > .separator , > .import test.csv ld_assay > > Here's my database / table: > CREATE TABLE

Re: [sqlite] How do you load a ".csv" and skip the first line?

2012-09-02 Thread Larry Brasfield
joe.fis...@tanguaylab.com wrote: Is there some way to load a ".csv" file into a SQLite database table when the first row (record) of the file contains headers? Awhile ago, I published a modification of the SQLite shell which I wrote specifically to solve this problem. When headers are turned

Re: [sqlite] How do you load a ".csv" and skip the first line?

2012-09-02 Thread Dominique Pellé
joe.fis...@tanguaylab.com wrote: > Is there some way to load a ".csv" file into a SQLite database table when > the first row (record) of the file contains headers? > > This does not work? > -- > .separator , > .import

Re: [sqlite] How do you load a ".csv" and skip the first line?

2012-09-01 Thread Ted Rolle, Jr.
Text editor to remove the offending line(s)? This way you can see what you've removed. The other solutions (tail, less, more) would work better for LARGE files. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] How do you load a ".csv" and skip the first line?

2012-09-01 Thread Udi Karni
If all else fails - after the import issue DELETE FROM XYZ WHERE ID = 'id' ; But - yes - adding the "skip=y" and "load=x" parameters (skip the first y rows in the .csv file, and stop after loading x rows) - to the .import utility would be most desirable. On Sat, Sep 1, 2012 at 12:31 PM,

Re: [sqlite] How do you load a ".csv" and skip the first line?

2012-09-01 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/09/12 12:19, joe.fis...@tanguaylab.com wrote: > Is there some way to load a ".csv" file into a SQLite database table > when the first row (record) of the file contains headers? You may want to consider using the APSW shell. It has a

Re: [sqlite] How do you load a ".csv" and skip the first line?

2012-09-01 Thread Petite Abeille
On Sep 1, 2012, at 9:19 PM, joe.fis...@tanguaylab.com wrote: > Is there some way to load a ".csv" file into a SQLite database table when the > first row (record) of the file contains headers? On *nix, any of tail +2, more +2, etc would do.