ISNUMBER
Returns true if and only if this string contains only numeric values. This function can be used only with SCRIPT function.
Function: ISNUMBER(INPUT_VALUE)
Examples:
- If PERSONIDNUMBER = ‘2020-04-30’
SCRIPT([PERSONIDNUMBER!='' && ISNUMBER(PERSONIDNUMBER)],{PERSONIDNUMBER;’’})
Here, SCRIPT function returns ‘’ i.e. EMPTY_STRING
- If PERSONIDNUMBER = ‘20200430’
SCRIPT([PERSONIDNUMBER!='' && ISNUMBER(PERSONIDNUMBER)],{PERSONIDNUMBER;’’})
Here, SCRIPT function returns PERSONIDNUMBER
Parameters:
INPUT_VALUE the sequence to search for
Returns:
TRUE if this string contains only numeric values, FALSE otherwise