How to specify row separators when importing into an sqlite db from a csv with non-default field and row separators ?

Question

I have a bunch of data that i exported from mssql using bcp with custom field and row separators.
I would like to import the data into an sqlite database. .
Is there an easy way to do this with .import and .separator ? .
Or do I need to use a newline as my row separator, alter the .import source, or make insert statments for each row...

Answer 1

Individual records should be on a new line.

Setting .separator will arrange the field separator. Do not quote, just type in your separating character after a single space.

To start the import, use .import FILE TABLE