I'm sure this question has been asked a thousand times, but I did not find a useable answer anywhere on the web.
How does one escape a in a CSV file so it will correctly import? I have data coming from a translation database. No, I cannot go fix the database, I can only massage the CSV and possibly request a tiny tweak to the module which generates the csv file. The source database is NOT sqlite. We have many occurrences where I need to escape a single " so it can survive and get into the database. Our separator has dutifully been changed to the | character. Why does it need to survive? There are many things like this: English TargetLanguage 2in 2" Nice huh? Under MOST text systems you can do something like &Quote or <&Quote> to replace a quote and make it pass through to the database. What escape sequences does the SQLite import utility recognize? Roland _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
