Starts With

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

Syntax & Usage

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

Example

In this example, a list of Manufacturers was configured, and the search string "o" set in the Starts With block. The function returns a list of elements in the Manufacturer hierarchy beginning with "o": Old Balance and Over Armour:

{StartsWith({AllMembers([manufacturers].[Manufacturer])},"o")}