Comparing 2 Strings

Beginner Questions
1

Sorry for the newb question. I have searched all the docs, but cannot find a simple way to compare 2 strings and output a new value depending on their match.

I am trying this formula in a data field…
if(String1=String2; “Match”; “Mismatch”)

Each String is a variable that is input. If the variables match it should output “Match”…if they don’t match…“Mismatch”.

This formula outputs a match every time regardless of the input strings.

What am I doing wrong?
image

2

@Matt_Lane

it’s just a matter of using Make operator instead of " = "

image
image690×599 26.2 KB

3 Likes
3

Oh my goodness. Haha…thank you for the response that should have been a bit more obvious. I forget all the time I can’t just write certain characters…I have to click the button!

Thank you again for the help!!!

3 Likes
4

You can also “write” the special characters and variables like this

{{=}}

{{emptystring}}

{{newline}}

{{now}}

etc.

5 Likes