title: sqlite3 import with quotes
body: <p>I am trying to import a collection of data that has quotes within the fields.  They are currently tab separated.</p>
  
  <p>From what I can understand according to the docs (<a href="http://www.sqlite.org/cvstrac/wiki?p=ImportingFiles">http://www.sqlite.org/cvstrac/wiki?p=ImportingFiles</a>), the sqlite shell should interpret quotes literally and I assume that means I shouldn't have a problem.</p>
  
  <p>I've been running into a problem on this line:</p>
  
  <pre><code>1193782372  Lips Like Sugar (12" Mix)   Echo &amp; the Bunnymen 80's/12": The Extended Collection   a76d9b04-51d9-4672-801f-356ab36dbae7    ccd4879c-5e88-4385-b131-bf65296bf245    1abb270a-e791-407f-a989-ff3ad6f8401c
  </code></pre>
  
  <p>Since it isn't clear where the tabs are, I've included them in this following line.</p>
  
  <pre><code>1193782372\tLips Like Sugar (12" Mix)\tEcho &amp; the Bunnymen\t80's/12": The Extended Collection\ta76d9b04-51d9-4672-801f-356ab36dbae7\tccd4879c-5e88-4385-b131-bf65296bf245\t1abb270a-e791-407f-a989-ff3ad6f8401c
  </code></pre>
  
  <p>I'm trying to do the following but getting an error.</p>
  
  <pre><code>sqlite&gt; .separator \t
  sqlite&gt; .import ./file.txt table
  Error: ./file.txt line n: expected 7 columns of data but found 5
  </code></pre>
  
  <p>It works without the double quotes, but the quotes are important.  I don't seem to be able to escape the quotes with <code>\"</code> either.</p>
  
  <p>How can I properly import the data I want?</p>