2006/1/7, Jay Sprenkle <[EMAIL PROTECTED]>: > Have you tried "head" or "tail"? do you means the head command of the OS,say linux ? Not yet,using "head" or "tail" will be faster than sed?
As I see,many CSV files using \t as separator. And SQLite does not use \t,I have to use sed(or other tools) to change Tab to |. so My puzzle is why SQLite not support \t? > On 1/6/06, ronggui wong <[EMAIL PROTECTED]> wrote: > > I want to use .import to import a data file into SQLite.but the first > > line is the variable(fields),so I want to ignore it.delete the first > > row of the data is one solution,But the data file is large ,and try to > > use sed to delete the first row,it takes long time > > a|b|c > > 1|2|3 > > |3|1 >