Hi,
What is the best way to check if a global table's cell is blank/null?
I've tried the following, but it doesn't seem to work. It always true.
if (table[stepid]["VariableDurationMean"] != NULL)
Thanks,
Hai
Edit: Add test file: TestCellNull.fsm
A table cell can have different types of data assigned to it, and the comparison changes depending on what type the cell is using. This code snippet will do the appropriate comparison based off the type of data assigned to the cell:
Variant value = Table("GlobalTable1")[1][1];
switch(value.type) {
case VAR_TYPE_NUMBER: return value == 0;
case VAR_TYPE_STRING: return value == "";
case VAR_TYPE_ARRAY: return value.length == 0;
case VAR_TYPE_NODE: return value == nullvar || value == 0;
case VAR_TYPE_NULL: return 1;
}
For undefined/blank cell value in a global table, I am getting type = 3 instead.
This that expected?
DATATYPE_COUPLING 3
Are you getting the datatype of the cell or the type of the variant? Can you post an example of what you're doing?
I added a sample file.
Note that the global table values were imported from excel.
16 People are following this question.
