-18 1:44 p.m. (GMT-04:00)
To: qgis-user@lists.osgeo.org
Subject: Re: [Qgis-user] CSV layer, Time column null expressie to test
for NULL/empty?
Pff, ok found a solution:
"bezoek.begintijd" IS NULL
works
So if I want to test for empty strings, or NULL (like strings), AND real
NULLS,
You can also useCASEWhen field is null then 123else 321endKirk SchmidtSent from
my Galaxy
Original message From: Richard Duivenvoorde via QGIS-User
Date: 2023-01-18 1:44 p.m. (GMT-04:00) To:
qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] CSV layer,
Time column null
Pff, ok found a solution:
"bezoek.begintijd" IS NULL
works
So if I want to test for empty strings, or NULL (like strings), AND real NULLS,
I use now:
( "bezoek.begintijd" IS NULL OR "bezoek.begintijd" in ('', ' ', 'NULL') )
Regards,
Richard Duivenvoorde
On 1/18/23 18:31, Richard
We have csv data, which is loaded as layer via the Delimited Text Layer
provider.
The data contains both a date and a time column, which we have to format as
isodatetime using an QGIS Expression.
BUT sometimes time column is empty/no value (in which case we have to format it
as isoTIME