I'm using a tab-delimited .txt file to save my data before importing it into a SQLite database with the SQLite Manager add-on for Firefox.

I've tried a couple of ways to add carriage-return/line-feeds within my columns but failed mostly, ending up with SQLite treating them as multiple rows.

I added a carriage-return/line-feed in SQLite Manager and then looked at the format which seems to be just simple returns but copy-and-pasting that into a text file for later importation doesn't work.

How can I add carriage-return/line-feed into columns within a text file that I can later import into SQLite?

  • @MaxVernon Is it called a line brake? Maybe I made up break return; I thought HTML's <br> was short for break return but I could have totally just made that up myself. – user3306356 Apr 1 '16 at 3:19

In general, fields containing newlines should be enclosed in double quotes:

234,"test with
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
lines", 567
345,no quotes needed,678
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.