CONTAINS

Returns true if and only if this string contains the specified sequence of char values. This function can be used only with SCRIPT function.

Function: CONTAINS(INPUT_​FLD,SEARCH_​STRING,EXPECTED_​OUTPUT)

Examples:

  • If PERSONIDNUMBER = ‘2020-04-30’

SCRIPT([PERSONIDNUMBER!=''&&CONTAINS(PERSONIDNUMBER,‘2004’,TRUE)],{PERSONIDNUMBER;’’})

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

  • If PERSONIDNUMBER = ‘20200430’

SCRIPT([PERSONIDNUMBER!=''&&CONTAINS(PERSONIDNUMBER,‘2004’,TRUE)],{PERSONIDNUMBER;’’})

Here, SCRIPT function returns PERSONIDNUMBER

Parameters:

INPUT_​FLD the input field for whose value we will have a search

SEARCH_​STRING the sequence to search for

EXPECTED_​OUTPUT the expected result. This can be TRUE or FALSE.

Returns:

TRUE if this returns the EXPECTED_​OUTPUT, FALSE otherwise.