I need to import a file to a table but there are two delimiters used in the file; quotes and spaces. The first 2 columns are for metadata and use quotes, the remaining columns are financial data (a column for each month) separated by spaces. For example:
"Net Sales" "New York" 1000.00 999.00 1112.00 "Expenses" "New York" 555.00 600.00 500.00 Is there a way to import this file to SQLite when the delimiters are mixed? I'm looking for something similar to the MySQL import parameter "optionally enclosed by" where it knows to use the appropriate delimiter when it's encountered. Thanks. -- View this message in context: http://old.nabble.com/Import-File-with-Mixed-Delimiters-tp33107824p33107824.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
