[Qgis-user] Distincguis NULL and empty strings when reading CSV files

[Yann Voté]

Hi all,

Just wondering if there is a way to distinguish null values and empty 
strings when loading CSV files in QGIS.

What I tried so far is quoting empty strings like in the following example.

col1,col2,col3
1,,""

I was expecting col2 to be NULL and col3 to be an empty string. But 
actual result is that both col2 and col3 are NULL.

Is there another way ? Am I missing something ?

Thanks in advance.

Yann