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