rangenotmatch(
rangenotmatch(
TEXT
,
RANGE
)

The rangenotmatch( function returns false (0) if the text matches a 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 returns false if text matches a specified range.

    rangenotmatch("ABC","AZ") ☞ 0 (false)
    rangenotmatch("ABC7","AZ") ☞ -1 (true)
    rangenotmatch("Now","AZaz") ☞ 0 (false)
    rangenotmatch("Now is the time","AZaz") ☞ -1 (true)
    rangenotmatch("Now is the time","AZaz  ") ☞ 0 (false)

In the final example above, notice that there are two spaces at the end of the range. This allows text with spaces to match. Note: This function is equivalent to:

    stripchar(thetext,therange)<>thetext

See Also

- ?( -- allows a formula to make a true/false, yes/no decision.
- booleanvalue( -- converts a numeric or text value to Boolean (true/false).
- false( -- returns false.
- rangematch( -- returns true (-1) if the text matches a specified range.
- stripchar( -- extracts characters you don't want from a text item.
- switch( -- chooses from a list of values.
- true( -- returns true.

History

Version | Status | Notes
10.0 | No Change | Carried over from Panorama 6.0.