I am working on a dataset with > 1M rows, with a column 'Reported Results'.
In this column, approx. 3000 rows contain a '<' or '>' (always followed by a value, e.g. <100), all other rows are numeric. When importing the datafile, JMP marked the Data Type for this column as Character.
I tried converting the 5000 rows, containing a '<' or '>', by using Column Recode. I saved the script to File (see attached).
The new column, after recoding, maintains Data Type Character. When adjusting to Numeric, I obtain meaningless data.
I also tried: (a) first resetting my column 'Reported Results' to Numeric, and also (b) 'parse as numbers' in recode, but both alternatives didn't work either.
Using JMP 17.2.0
