Syntax for empty

[sbb]

What is the syntax to custom filter a field for all of the values that are empty (blank)? I tried ISEMPTY([GROUP_ID]), but it didn't work. 

[michael_treadwell]

ISEMPTY will only match NULL fields and fields that equal ''

To match NULL fields, fields that equal '', or fields that contain only spaces, try this in the formula tool

REGEX_Match([test_string], '\s*')

[jdunkerley79 · Accepted solution]

I'd go for 

IsNull([Group_ID]) OR Trim([Group_ID])=''

 assuming you want both nulls and whitespace

[sbb]

I filtered with GROUP_ID = "" and this seemed to work. 

[sbb]

thank you for the suggestions guys.

[Aaron_dup_9]

I would still add the NULL check as well just in case there are some in there or there might be some in there in the future.