ISBLANK( ) function

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

Syntax

ISBLANK(string)

Parameters

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.

Remarks

This function can be used during the data integrity phase of an analysis project to identify fields with missing data, which may indicate issues with the source data.

In order for the function to evaluate to true, the input value must be entirely blank (i.e., contain only spaces), or a zero-length string.

The function only identifies true blanks in printable data, not invalid characters that appear as blanks in a view. It may not return useful results when used with character fields that contain null characters. ACL 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.

Examples

Example Return value

ISBLANK(" A")

F

ISBLANK(" ")

T

ISBLANK("")

T

ISBLANK(Address)

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



(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback