, )

---

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.