SQLite Forum

sqlite-gui application
Login
As a long-time Perl programmer having to deal with various 'source' files for DB creation, I have discovered that using a pipe symbol '|' as a field  separator  is less head-ache. It is vary rarely used in common text, thus not likely to be interpreted as anything else. It's easy to split on. So if you have control over the source file, consider using the pipe symbol as a field separator. My 2ยข.