IsEmpty-func
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.
IsEmpty()
int IsEmpty(string str$)
str
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.
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)
Find, Search, Value , Compare