In CSV import dialog, add option to treat values with leading zeros as text

[davidlgalt]

I work with a number of datasets that have code fields in them. The values often only contain numbers with one or more of the first digits as zeros. If the import dialog for CSV files had a checkbox (boolean) to treat fields with leading zeros as text then these fields would be able to be correctly imported.

The algorithm would iterate through all the values and would detect occurrences where the first position was 0 but the second position was not a decimal character. If any of these occurred then the field would be imported as text, even if all values contained only numbers and decimal characters.

[i-s-o]

I find declaring the field types (in .csvt/.tsvt files) very useful: no guessing = no unexpected results!
See: https://gdal.org/drivers/vector/csv.html

To test, drag and drop the following (as a zip file) onto QGIS:
test.zip

My experience with "Add Delimited Text Layer" is less than ideal.

[alexbruy]

Duplicates #21113.