I have a character field containing a mix of numeric and character data (ie. <20 0.555 4500 NA etc etc).
I want to select only numeric data and compare with a similar field for comparison. So I wrote:
IF VERIFY(EDRESULT,' 0123456789.') NE 0 THEN ;
IF INPUT(EDRESULT,8.2) < INPUT(EDLORNG,8.2) THEN EDFLAG = 'L';
ELSE IF INPUT(EDRESULT,8.2) > INPUT(EDHIRNG,8.2) THEN EDFLAG = 'H';
But I'm not sure how format I should use to read in these data. Since it contains different decimal points, I can't just use one format (8.2). It gives a mix of correct and incorrect answers when I use this format.