=EXTRACTOPERATOR("Salary > 100000") -> {">",GREATERTHAN} =EXTRACTOPERATOR("Department <> IT") -> {"<>",NOTEQUAL} =EXTRACTOPERATOR("Department != IT") -> {"!=",NOTEQUAL}
DEFINE( EXTRACTOPERATOR, LAMBDA( condition_string, IFS( ISNUMBER(FIND("<>", condition_string)), HSTACK("<>", NOTEQUAL), ISNUMBER(FIND("<=", condition_string)), HSTACK("<=", LTE), ISNUMBER(FIND(">=", condition_string)), HSTACK(">=", GTE), ISNUMBER(FIND("<", condition_string)), HSTACK("<", LESSTHAN), ISNUMBER(FIND(">", condition_string)), HSTACK(">", GREATERTHAN), ISNUMBER(FIND("!=", condition_string)), HSTACK("!=", NOTEQUAL), ISNUMBER(FIND("=", condition_string)), HSTACK("=", EQUAL), OTHERWISE, NA())))
Help us optimize this function