RangeListContains

Description

Returns True if the Range List contains the specified value.

Syntax

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

The RangeList parameter looks like this: 1-10,101-10000,9999999-10000000000

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 checks the validity of the RangeList and combines ranges with contiguous boundaries.