[<<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