Advanced filter control - How to apply 'ends with' logic?

[sergiy_borovik]

Hello everyone.

How to apply 'ends with' logic in Advanced filter control. This option is absent in drop-down.

Thank you.

[lauratilton · Accepted solution]

Here's what I would do:

Create a text parameter called "Ends With" and use that in an input box control.

Create a calculated field called "Matches" that looks something like this (where TextField is the field you want to match on Ends With):
IF(RIGHT_TEXT(TextField, LENGTH(Ends With))=Ends With, TextField, null)

If you use the Matches field in a table, it will return only the TextField values that end with your Ends With entry. (You can put a filter on the table to exclude the null record.)

Here's my quick example.

[sergiy_borovik]

Thank you!