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:
|
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