sqlite3 import with quotes

Sqlite3's .import tool behaves as if its input is in comma-separated-values format, even if .separator is not a comma. You can escape quotes (") by doubling them ("") and quoting the entire field they occur in.

I got a clean .import of your test data after running it through the following filter:

sed 's/"/""/g;s/[^\t]*/"&"/g' file.txt >quoted.txt

The sqlite3 command-line tool isn't very flexible in what import formats it supports.

You could

• change the import file to add double quotes around and escape double quotes in fields; or

• convert the import file into a series of SQL statements:

  INSERT INTO MyTable VALUES(
      1193782372,
      'Lips Like Sugar (12" Mix)',
      'Echo & the Bunnymen 80''s/12": The Extended Collection',
      'a76d9b04-51d9-4672-801f-356ab36dbae7',
      'ccd4879c-5e88-4385-b131-bf65296bf245',
      '1abb270a-e791-407f-a989-ff3ad6f8401c');
  

  or

• write your own import tool.