I have done something similar, but I was willing to have punctuation too.  My 
intent was to just get rid of unprintable/escape characters.  If you do an:
   XXX=OCONV(XXX, "MCP")
it will convert all nonprinting characters to tildas ("~").  You could convert 
all PRINTABLE but unwanted characters to null: 
   CONVERT "~...@#$%^&*()_+" TO "" IN XXX
(or something like that).


John Israel
Senior Programmer/Analyst
Dayton Superior Corporation
1125 Byers Road
Miamisburg, OH  45342


-----Original Message-----
From: [email protected] 
[mailto:[email protected]] On Behalf Of Linda D Law
Sent: Monday, August 23, 2010 8: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

Reply via email to