Linda !
Yes there is a way to negate ANY set of characters for
a convert - at least if your running ASCII and not unicode:
First, make a string that contains all possible characters:
ALL = ''; FOR II = 1 TO 256; ALL := CHAR(II-1) ;
NEXT II
Then remove all the chars you want to keep:
SCRUB = CONVERT( WANTED,'',ALL)
Now you have a string that contains all the characters
you want to get rid of, use it in a convert to replace
them with spaces - or empty string to delete them:
CLEAN = CONVERT(SCRUB, ' ', DIRTY)
-- mats
---------------------------------------------------------------------
Mats Carlid ADB-Krafter AB
[email protected] [1] www.adbk.se [2]
*46 (8) 445 26 70 www.liftit.se [3]
----- Orginal Meddelande -----
Från:"Linda D Law"
Till:"U2 Users List"
Cc:
Skickat:Mon, 23 Aug 2010 12:53:07 +0000
Ämne:[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] [4]
http://listserver.u2ug.org/mailman/listinfo/u2-users [5]
Links:
------
[1] mailto:[email protected]
[2] http://www.adbk.se/
[3] http://www.liftit.se/
[4] mailto:[email protected]
[5] http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
