The endswith operator returns true if the value on the left ends with the value on the right, false if it doesn’t.


This operator has two parameters:

value1 – The first numeric or text value.

value2 – The second numeric or text value.


The endswith operator compares two values (usually text) to see if the value on the left ends with the value on the right.

"abcdef" endswith "def" ☞ true
"abcdef" endswith "cde" ☞ false
12345 endswith 45 ☞ true
12345 endswith 23 ☞ false

As the final two examples show, the endswith operator can work with numbers as well as text – it simply automatically converts the number into text before comparing.

As a more practical example, the formula below will be true if the Name field or variable ends with the letters d.d.s..

Name endswith "d.d.s"

This formula will be true if the if the name is Mark Wilson D.D.S., and false if the name is Stan Johnson.

Note: The endswith operator does not worry about upper or lower case, so Mark Wilson D.D.S. or Mark Wilson D.d.s. will also produce true results. If upper and lower case are important to you use the matchexact operator.

See Also


10.0UpdatedCarried over from Panorama 6.0, but also now allows numeric as well as text parameters.