Vince, Never pays to hurry!
Yes, you're right. What I meant to type was CHRTRAN( string, CHRTRAN( string, "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz", SPACE(0) ), SPACE(0)) This removes all non-alpha characters. (in case, later the subject string would contain other non-desirable characters). Slightly less readable, but could be encapsulated in a function such as TRIM_OUT_ALL_BUT( tcString_Subject, tcString_Good_Chars ) Blue Skies! Joe [Image] Vince Teachout wrote: > Joe De Ville wrote: > > To remove all but legitimate alpha characters, use CHRTRAN( string, > > "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz", "" ) > > Wouldn't that remove all legitimate alpha and just leave the rest? I > think he wants: > > CHRTRAN( string, ".', 1234567890", "") > > The first 4 chars are period, apostrophe, comma, and space. He could > add whatever else he needs stripped out, as well. > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
