IsEmpty

1 Description
2 Syntax
3 Parameters
4 Return
5 Examples
6 See Also

Description

The IsEmpty() function is similar to MS Excel's ISBLANK function, and is used to determine whether a string or worksheet cell is empty or not. Note that cells containing missing values, denoted by "--", are not considered empty.

Syntax

int IsEmpty(string str$)

Parameters

str

is a string, worksheet cell address, or a vector (e.g. col(A)).

Return

If the cell contains a string, numeric or missing value ("--"), the function returns 0.

If the cell or string is empty, the function returns 1.

Examples

string str1="";
isempty(str1$)=; //return 1
col(A)[1]$=str1$;
col(A)[2]$="hello";
isempty(col(A)[2]$)=; // return 0
isempty(A); //returns a dataset contains 1 and 0 respectively (Spreadsheet Cell Notation syntax for Set Values dialog box only)