All of the operators supported in Panorama formulas are listed below:
• - -- The - operator subtracts the numeric value on the right from the numeric value on the left.
• * -- The * operator multiplies the numeric value on the left by the numeric value on the right.
• / -- The / operator divides one numeric value by another.
• \ -- The \ operator performs integer division.
• ^ -- The ^ operator raises a number to a power.
• + -- The + operator works differently depending on the type of operands used with it. If both operands are numeric, it does numerical addition. If either operand is text the + operator concatenates (joins together) the two operands.
• < -- The < operator compares two values to see if the first value is less than the second value.
• <= -- The <= operator compares two values to see if the first value is less than or equal to the second value.
• <> -- The <> operator compares two values to see if they are different.
• = -- The = operator compares two values to see if they are the same.
• > -- The > operator compares two values to see if the first value is greater than the second value.
• >= -- The >= operator compares two values to see if the first value is greater than or equal to the second value.
• and -- The and operator returns true if both operands are true.
• beginswith -- The beginswith operator returns true if the value on the left starts with the value on the right, false if it doesn't.
• contains -- The contains operator returns true if the value on the left contains the value on the right, false if it doesn't.
• endswith -- The endswith operator returns true if the value on the left ends with the value on the right, false if it doesn't.
• like -- The like operator checks to see if the text on the left matches the wildcard pattern specified on the right.
• match -- The match operator checks to see if the text on the left matches the wildcard pattern specified on the right.
• matchexact -- The matchexact operator checks to see if the text on the left matches the wildcard pattern specified on the right.
• mod -- The mod operator computes the remainder (modulo) after integer division.
• not -- The not operator reverses a boolean value.
• notcontains -- The notcontains operator returns true if the value on the left does not contain the value on the right, false if it does.
• notmatch -- The notmatch operator checks to see if the text on the left does not match the wildcard pattern specified on the right.
• notmatchexact -- The notmatchexact operator checks to see if the text on the left doesn't match the wildcard pattern specified on the right.
• or -- The or operator returns true if either operand is true, or false if both are false.
• regexmatch -- The regexmatch operator checks to see if the text on the left matches the regular expression on the right (see Regular Expressions).
• regexmatchexact -- The regexmatchexact operator checks to see if the text on the left matches the regular expression on the right (see Regular Expressions).
• soundslike -- The soundslike operator compares two words to see if they "sound like" each other.
• Text Funnels -- Text funnels strip off the beginning and/or end of a text string based on your specifications.
• xor -- The xor operator returns true if one of the two parameters is true, false if neither or both are true.