How can you identify if a field has Null values or blank? And how can I convert blank values to Null values?

[jblomqvist]

Hi all,

How can you identify if a field has Null values or blank? And how can I convert blank values to Null values?

Is there a simple demo app that anyone can share to demonstrate this please?

The reason I ask is because

I am trying to use

Set NullValue = '<Unknown>'; and use NULLASVALUE function for some fields but I don't they are null.

[maxgro]

check if field is nulll

if(isnull(field), 'is null', 'is not null') as newfield

check null or blank

if(len(trim(field))=0, 'is null or blank', 'is not null blank') as newfield

convert blank to null

if(len(trim(field))=0, null(), field) as field