Find blanks in text field

[#1]

I tried to use the expression

count(IF(text=' ',items))  to find all items where the text field is blank - but?????????????????????????

[manuelreimitz · Accepted solution]

=count(if(len(trim(text)) = 0, item))

do the "trim" operation in load script and flag the dataset!

LOAD

     id,

     text,

     f(len(trim(text)) = 0, 0, 1) as EmptyFlag,

     item

RESIDENT Table:

[#3]

Hurra - it works