Function: IsBlank


Returns 1 if string is empty or contains only spaces, otherwise returns 0 (zero).




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.

Intellectual Property Rights Notice | Technical Support