Is this a better .csv?

Re:Is this a better .csv? by zzo38computer on Friday March 13, 2020 @11:38PM (#22572995)

The SQLite command shell supports the format described there. I have also independently used the same format too. But now, they have a name for it, which can be useful.

One variant I have sometimes used is DLE to escape the next character if it is a control character that should be part of the data.

[ Parent | on HN ]

Re:Is this a better .csv? by reactorpres on Sunday March 15, 2020 @05:50PM (#22587128)

Unfortunately, I was unable to get the .separator command to accept the control characters. It always threw an error stating that multi-character separators are not allowed. Since those characters are in the regular ASCII table, I wouldn't have thought they were multi-character/byte characters, but maybe sqlite just doesn't allow the use of non-printing characters.

[ Parent | on HN ]

Re:Is this a better .csv? by zzo38computer on Monday March 16, 2020 @04:33AM (#22590992)

To use control characters as separators, type:

  .mode ascii

[ Parent | on HN ]