Detecting tab as CSV separator
Posted: 11 Nov 2009, 18:02
I often use the Database Viewer for csv files and the like. I always used the "Auto-Select" settings, because those worked okay in most cases.
But version 2.52 changed the rules. And I think they have not been improved.
For 99.9% of the files containing TABs, TAB is the separator. But for many of those files, it now picks some other character.
Example: And another one: Aside: try End in this last example: the long last column overwrites itself...
I now use Tabulator (Tab?) as the default Separator to circumvent the new rule in most cases.
I think the old behavior was "good enough".
But version 2.52 changed the rules. And I think they have not been improved.

For 99.9% of the files containing TABs, TAB is the separator. But for many of those files, it now picks some other character.
Example: And another one: Aside: try End in this last example: the long last column overwrites itself...
I now use Tabulator (Tab?) as the default Separator to circumvent the new rule in most cases.
I think the old behavior was "good enough".
