Question

How can we compare two text values

Hi All,

for example "batting" is text1 and "bat" is text2

if batting compare with bat then it should write True. because bat word is there in batting word

Is there any logic for this ?

Logic for find() function as suggested by Purvaja

a!localVariables(
  local!x: find("bat", "batting"),
  if(local!x <> 0, true, false()),
)

You can also use search() or searchb() funtions for the same in place of find() function.

One thing to note is that find() is case sensitive while search() is case insensitive depending on what your use case may be.

Sign up