Ends With

Returns a subset of elements in a list based on a string search on captions. The search is based on a 'ends with" operation.

Syntax & Usage

EndsWith([LIST], search string)
  • Configure the list that should be filtered.
  • Add the Ends With block to the list block; in the Insert Arguments window, enter the search string.


In this example, a list of Manufacturers was configured, and the search string "son" set in the Ends With block. The function returns Woolson:


In this example, the list was parameterized, and connect to a global text parameter containing a list of captions.

The parameterized list produced a button slicer, allowing the user to filter the query by the desired suffix: