How to add in carriage-return/line-feeds without starting a new row in a tabbed txt SQLite import
In general, fields containing newlines should be enclosed in double quotes:

123,test,456
234,"test with
multiple
lines", 567


When using quoted fields, any quote inside the field has to be escaped by another quote (or a \, unix style), and the field itself has to be quoted too:

123,"24"" monitor",456
234,"test with
multiple
lines", 567
345,no quotes needed,678