[QGIS-Developer] delimited text import still broken

[Tobias Wendorff]

Hi there,

sorry for bumping this, but it's really destroying incoming data.
https://issues.qgis.org/issues/18601

CSV is a bad format, we all know that. But it's spread widely in
context of OpenData, since it's pure text.

Like stated in the issue, a quick work-around is to cast all incoming
fields to text. Then it's not destructive anymore.

A better approach is the one from Excel or LibreOffice and the XLSX
importer. It lets you choose the the field's type. New Excel also
supports reading the first 200 or 100% of the lines to identify the
type. It's better than some regex guessing based on a few head lines.

Best regards,
Tobias