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