Linda I would use CONVERT. It can be done in one pass:
REM.STRING = "!...@#$%^&*()_+-={}|[]\;':",./<>?`~ ":CHAR(9) ;* Make your
string of characters to Remove
NEW.STRING = CONVERT(REM.STRING, SPACE(LEN(REM.STRING)), OLD.STRING)
David A. Green
(480) 813-1725
DAG Consulting
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Linda D Law
Sent: Monday, August 23, 2010 5:53 AM
To: U2 Users List
Subject: [U2] EREPLACE Function
Is there a way to negate the selection criteria in the EREPLACE function?
For example, I want to replace every character that is not A-Z, a-z, 0-9
with a blank.
Perhaps there is a better function for this?
Thanks,
Linda Law
University of Georgia
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
