On 28/04/2021 15:37, Utkarsh Singh wrote:
+List of preferred separator (in order of preference):
+comma, TAB, semicolon, colon or SPACE.
I will hardly be using this feature heavily, so I do not insist that the
following must be taken into account. Just some considerations...
There are locales where comma is used as decimal separator 23,5 (e.g.
ru_RU.UTF-8). Office software and applications oriented to office users
often use semicolon as field separator. There are still may be plenty of
numbers with fractional part, so with commas. Likely ";" should be tried
at first for such locales.
However the same user may have enough CSV files that are really "comma
separated", e.g. results of numerical simulation where localization is
intentionally ignored, data obtained from some equipment, etc.
Some files (e.g. downloaded bank statements) may be in legacy 8-bit
encoding instead of UTF-8.
As a result, sometimes the only convenient way is to try various options
with interactive preview.