RangeListContains

Description

Returns True if the specified list of ranges contains the specified value.

Syntax

RangeListContains(RangeList: String, Value: Integer, Delimiter: String): Boolean

RangeList is a list of integer ranges to search, separated by the specified delimiter. For example, 1-100, 201-300

Value is an integer value to search for in the list of ranges.

Delimiter is the character to use to delineate items in the string list. Supported special characters:

[comma]
[space]
[tab]

Note:

You must use the name of the delimiter (not the character) and include brackets around the name.

Example

RangeListContains(PropValue(MyRangeList),1,[Comma])

If the property MyRangeList' has a value of 1-10, 101-10000, then the return value is True, because 1 is contained in the specified range. However, RangeListContains(PropValue(MyRangeList),11,[Comma]) returns False, because 11 is not contained in the specified range.

Note:

If you change MyRangeList to "1-5,6-10,101-1000", Data Relationship Management replaces this value with "1-10,101-1000", because it verifies RangeList and combines ranges with contiguous boundaries.