I need to remove multiple undesirable symbols, chars, and spaces, from multiple variables.
This is the kind of code I'm using so far:
do unwanted = '"', ';', '|';
VAR1 = compbl(transtrn(compress(VAR1,,'c'), strip(unwanted), trimn(''))); VAR2 = compbl(transtrn(compress(VAR2,,'c'), strip(unwanted), trimn(''))); VAR3 = compbl(transtrn(compress(VAR3,,'c'), strip(unwanted), trimn(''))); VAR4 = compbl(transtrn(compress(VAR4,,'c'), strip(unwanted), trimn(''))); VAR5 = compbl(transtrn(compress(VAR5,,'c'), strip(unwanted), trimn(''))); VAR6 = compbl(transtrn(compress(VAR6,,'c'), strip(unwanted), trimn(''))); VAR7 = compbl(transtrn(compress(VAR7,,'c'), strip(unwanted), trimn(''))); end;
As you can see, the same extact expression is used for all 7 variables.
Can you please suggest a more tidy way to set this up, so that I only need to use the expression 1 place?
EDIT: Don't know why is the code isn't displayed properly, here's a screenshot.
... View more