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.mcdonn...@opw.ie Email Disclaimer: https://www.opw.ie/en/disclaimer/ -----Original Message----- From: Qgis-user <qgis-user-boun...@lists.osgeo.org> On Behalf Of Yann Voté Sent: 15 April 2020 10:58 To: qgis-user@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@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
