Hello! I have a result variable that is a string and I'm splitting it into two variables, one for numeric data and one for character data. For example, if my original variable is RESULT, I want to split it into NUM and CHAR. Right now I'm using something like if ANYALPHA(RESULT)>0 then CHAR=RESULT; ELSE NUM=INPUT(RESULT, BEST.); The problem happens when my RESULT variable has a non-alphanumeric character because then I can't use INPUT to change the string to numeric. RESULT NUM CHAR 'Negative' 'Negative' '124.3' 124.3 '<50' <50 'Other' 'Other' '<99.9' <99.9 I know I can use COMPRESS(RESULT, '<'), but is there another way that doesn't rely on me knowing the specific character? The dataset I'm using is huge, so there could be variety I don't know about. Is there a generalized "remove non-math" type of function I can use so I can keep decimals and negatives but remove other symbols?
... View more