LENGTH

This can be used to compare the string length. It has to be used with conditional operators and numeric value. This function can be used only with SCRIPT function.

Function: LENGTH(INPUT_​VALUE)

Examples:

  • If PERSONIDNUMBER = ‘2020-04-30’

SCRIPT([PERSONIDNUMBER!='' && LENGTH(PERSONIDNUMBER)>15],{PERSONIDNUMBER;’’}

Here, SCRIPT function returns ‘’ i.e. EMPTY_​STRING

  • If PERSONIDNUMBER = ‘20200430’

SCRIPT([PERSONIDNUMBER!='' && LENGTH(PERSONIDNUMBER)=8],{PERSONIDNUMBER;’’})

Here, SCRIPT function returns PERSONIDNUMBER

Parameters:

INPUT_​VALUE the LENGTH to compare with

Returns:

TRUE if this LENGTH condition satisfies, FALSE otherwise