Is there an 'includes' or 'contains' function for an IF statement in a custom expression

[christopher sawtelle 2]

Is there an "includes" or "contains" function for an IF statement in a custom expression I know we have on ina CASE statement but wondering about the IF. Can't seem to get one to work.

[Manoj Chaurasia]

You can sort it out by lowercase the [column].

[David Courtin]

Hi Chris, you can use

~=, on the expression, here is the help content

Can be part of an 'If' or 'Case' statement. Returns true if the Arg2 regular expression string matches the Arg1 string.

Examples:

If( "aab" ~= "a+" , "true", "false" )

Case when "aba" ~= ".a+$" then "true" else "false" end

OR

the Find function, should the value is a Text, the result is 0 or null if their is no matching or the index of the first occurence.

[christopher sawtelle 2]

Yea, this seems to work to a point but how could I do a compound statement such as if([column] ~= "apple" or "pear",1,0) it works fine for apple and find all variations but I may have multiple words to look for in a description.

[christopher sawtelle 2]

Ok just figured it out.

if([column] ~= "apple" or [column] ~= "pear",1,0)

This will work nicely I think.

[christopher sawtelle 2]

Found out one more piece of useful information. This is case sensitive so "Apple" is different than "apple". May be obvious to some but I didn't think of it at first.

[Shaun Simon]

Chris I noticed the case sensitivity so I generally compare string values as Trim(Upper([stringColumn])) ~= "this+" so that case and white spaces doesn't become a factor.

[Donald Johnson]

thne its:

 

if([column] ~= "[aA]pple" or [column] ~= "[pP]ear",1,0)