Determines the common denominator between two strings on the basis of
 individual characters

     CHARONLY(<cString1>,<cString2>) --> cString


     <cString1>  Designates a sequence of characters that are not removed
     from <cString2>.

     <cString2>  Designates the string that is processed.


     CHARONLY() returns the processed string <cString2>.


     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).


     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")



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.