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

[Richard McDonnell]

Hi,
You should try a space in column 3, as in...
col1,col2,col3
1,," "




——
Richard McDonnell MSc GIS, FME Certified Professional
FRM Data Management

——
Oifig na nOibreacha Poiblí
Office of Public Works

Sráid Jonathan Swift, Baile Átha Troim, Co na Mí, C15 NX36
Jonathan Swift Street, Trim, Co Meath, C15 NX36
——
M +353 87 688 5964   T +353 1 647 6543
https://www.opw.ie

——
To send me files larger than 30MB, please use the link below https://filetransfer.opw.ie/filedrop/richard.mcdonnell@opw.ie

Email Disclaimer: https://www.opw.ie/en/disclaimer/
-----Original Message-----
From: Qgis-user <qgis-user-bounces at lists.osgeo.org> On Behalf Of Yann Voté
Sent: 15 April 2020 10:58
To: qgis-user at lists.osgeo.org
Subject: [Qgis-user] Distincguis NULL and empty strings when reading CSV files

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
_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user