ISBLANK( ) function
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.
ACL Scripting Guide 14.1