On 23/08/10 15:34, David A. Green wrote:
> 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)
>
That assumes there aren't any other control characters etc in there.
The sure way is to CONVERT all the characters you want to *keep* to
nothing, assigning the result to a new variable.
Then CONVERT all those characters to space.
Cheers,
Wol
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
