@LIKE

Returns a member set of member names that match the specified pattern.

This function can be used on unique and duplicate-name outlines.

Syntax

@LIKE(pattern, topMbrinHierarchy, [escChar])
Parameter Description

pattern

The character pattern with which to compare to members in the outline, including a single wildcard character:

  • %: The percentage sign allows matching to a string of any length (including zero length).

  • _: The underscore allows matching on a single character in a member name.

topMbrinHierarchy

A fully qualified member name on which to base the member search. The specified member and its aliases, and all of its descendants, are included in the search.

To search the entire outline, provide an empty string ("") for this parameter. For example, @LIKE("100%", "").

escChar

Optional: A one-byte-length escape character to use if the wildcard character exists in member names.

If you do not specify an escape character, a backslash (\) is assumed.

Example

The following examples are based on the following duplicate-name outline:

Product
   100
      100–10
         100–10–10
      100–20
      100–30
   200
      200–10
      200–20
      200–30
   300
      300–10
      300–20
   Diet
      100–10
         100–10–11
      200–10
      300–10
   Bottle
      200–10
      300–20
@LIKE(“100%”, “Product”)

Returns members 100, 100-10, 100-20, and 100-30.

@LIKE(“30_”, “Product”)

Returns member 300.

@LIKE(“200\_”, “Product”, “\”) 

If member 200 has children named 200_10 (note the underscore, _), 200-20 (note the dash, -), 200_30 and 200-40, returns those members whose name contains an underscore: 200_10 and 200_30.

See Also