ISBLANK( ) function

Returns a logical value indicating whether the input value is blank.

Syntax

ISBLANK(string)

Parameters

Name	Type	Description
string	character	The value to test for blank data.

Output

Logical. Returns T (true) if the string parameter value is blank, and F (false) otherwise.

Examples

Basic examples

Returns F:

ISBLANK("  A")

Returns T:

ISBLANK("  ")

ISBLANK("")

Returns T for all values in the Address field that are blank, and F otherwise:

ISBLANK(Address)

Remarks

When to use ISBLANK( )

Use ISBLANK( ) during the data integrity phase of an analysis project to identify fields with missing data, which may indicate issues with the source data.

What is blank input?

For the function to evaluate to true, the input value must be one of the following:

entirely blank (that is, contain only spaces)
a zero-length string

The function only identifies true blanks in source data, not invalid characters that appear as blanks in a view.

Null characters

ISBLANK( ) may not return useful results when used with character fields that contain null characters. Analytics uses the null character to indicate the end of a string, and for this reason the ISBLANK( ) function will not read any character data that follows a null character, including blanks.