SQLite Forum

How to import multi-line feeds?
Login
I want to `.import` a file where some fields contain line feeds (LF) encoded as some unique string pattern.

I know with SQL one can use the `|| char(10) ||` trick.

But, how to do the same with the `.import` shell command?

Is there some way to tell the SQLite3 shell to interpret a certain char sequence as LF during `.import`?  For example, interpret `\n` as LF?