Kris Van Bruwaene
Reputation: 47
Sqlite3 import csv with CRLF (2 chars) as row separator
I want to import a csv file with TAB column separator and CRLF (2 chars) as row separator. I use:
.mode ascii
.separator "\t" "\r\n"
to which sqlite3 complains:
Error: multi-character row separators not allowed for import.
What can I do?
Upvotes: 0
Views: 20
Answers (0)
Related Questions
- sqlite3 import csv with column and row separator
- Improve INSERT-per-second performance of SQLite
- How to import CSV file data into a PostgreSQL table
- Skip rows during csv import pandas
- How to add header row to a pandas DataFrame
- When should I use curly braces for ES6 import?
- UPSERT *not* INSERT or REPLACE
- CSV file written with Python has blank lines between each row
- Import multiple CSV files into pandas and concatenate into one DataFrame
- sqlite3 import csv file