Function: IsBlank
Description
Returns 1 if string is empty or contains only spaces, otherwise returns 0 (zero).
Syntax
IsBlank(string)
Arguments
string can be a character field, an expression that results in a string or a function that returns a string.
Return value
This function returns a number: 1 if the field is empty, 0 if the field contains data.
Calculated field example
If the Amount field contained no value, or just spaces, the following calculated field expression would return a 1 (indicating that the field is empty): IsBlank(Amount)
Filter/Find example
Records with a blank Amount field can be selected or found using the expression: IsBlank(Amount)=1
© 2024 Altair Engineering Inc. All Rights Reserved.