ISNULLORWHITESPACE

Syntax

ISNULLORWHITESPACE (expression)

Description

ISNULLORWHITESPACE checks to see if the value in expressionis Null, empty, or contains nothing but one or more spaces (whitespace) and returns True or False based on the result. Whitespace refers to space, tabs, or certain Unicode characters identified as blanks..

Arguments

expression

Any valid expression, a Null value, empty, or whitespace.

Returns

If expression is Null, empty, or a string containing only whitespace, returns a Boolean True.

If expression is not Null, empty, or contains only spaces, returns a Boolean False.

Remarks

Whitespace includes spaces, tabs, and newline characters.

Examples

The following formula checks to see if the value for MyEntity.LastName is Null, empty, or contains nothing but spaces, and if so, provides a default value:

IF(ISNULLORWHITESPACE(MyEntity.LastName), "MissingLastName", MyEntity.LastName)

Returns:

— The value in LastName.

— "MissingLastName", if the value in LastName is Null, empty, or contains nothing but spaces.

Related Topics

Logical Functions

IFNULLUSE

ISNULL

ISNULLOREMPTY