Hi all, hopefully a simple formula request for you. I'm trying to use a formula in search criteria to find the last character of a text string; ie, 'ends with' character X. Is this possible? The length of the string is variable.

You should be able to accomplish that using a combination of: https://www.techonthenet.com/oracle/functions/substr.php And: https://www.techonthenet.com/oracle/functions/length.php

You should be able to create a Formula (Text) filter criteria with a formula like this, to extract only the last character of the field:

SUBSTR({field}, -1)

THANK YOU!