CONTAINS_IC

Owned by Charles Bishop (Deactivated)
Jan 30, 2018

Syntax

CONTAINS(<string>;<string>)

Description

Returns a Boolean value if the string contains the desired characters (2nd argument) or not. This operation isn't case sensitive, since IC stands for "ignore case". CONTAINS_IC returns false if one of the arguments is <null>.

Examples

Column1

Column2

CONTAINS returns

United Statesunited statestrue
United StatesUnitetfalse
GermanyGermanytrue
Germanygertrue
United KingdomKindfalse
nullKindfalse