rangecontains(
TEXT
,
RANGE
)

The rangecontains( function checks to see if the text contains any characters in the specified range.


Parameters

This function has two parameters:

text – text to check.

range – specifies what characters are allowed to match. The range must be a series of character pairs, for example AZ for upper case alphabetic characters, AZaz for upper and lower case, 09 for numeric digits, etc. To match a single character, repeat that character twice, for example %% to match the percent symbol. Multiple ranges can be combined by appending them, for example AZaz09 ..??!!,, will match common English text (letters, numbers, spaces and sentence punctuation).


Description

This function checks to see if the text contains any characters in the specified range. If the text contains any characters in the specified range the function returns true, otherwise it returns false. For example,

rangecontains(Company,"09")

will return true if the company name contains any numeric digits, false if it doesn’t.

Here are some additional examples:

rangecontains("ab2c","09") ☞ -1 (true)
rangecontains("abc","09") ☞ 0 (false)

Note: This function is equivalent to:

stripchar(thetext,therange)<>""

See Also


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0.