[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
CHARONLY()
Determines the common denominator between two strings on the basis of
individual characters
------------------------------------------------------------------------------
Syntax
CHARONLY(<cString1>,<cString2>) --> cString
Arguments
<cString1> Designates a sequence of characters that are not removed
from <cString2>.
<cString2> Designates the string that is processed.
Returns
CHARONLY() returns the processed string <cString2>.
Description
CHARONLY() removes all characters from <cString2> that are not in
<cString1>. The function is particularly useful when comparing data
that should have a standard format but has been input by different
people. This category can consist of things like telephone numbers,
part numbers, customer numbers, etc. (see example).
Example
Since numbers are the only characters that are relevant in a telephone
number, any characters that are not numbers are removed. The result in
each case is "2133907923":
? CHARONLY("0123456789", "213 - 39 07 923")
? CHARONLY("0123456789", "213 / 390 7923")
See Also:
WORDONLY()
CHARREM()
CHARONE()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson