Dears,
Started with JMP few weeks ago !! It's a naive question.
I am trying to convert a column Data type from Character to Numeric, however i am losing the all the Numeric values from the column while converting the data type to Numeric.
Please find the attached screenshots for the same.
How to retain the numeric values from a column when i change it's data type from Character into Numeric??
Tried by replacing the characters using following commands,
values1 = dt:RequiredColumn<<Get Values;
Regex( :RequiredColumn, "[^0-9]", "", GLOBALREPLACE );
with this all the numeric values are also getting replaced.
Simply i would like to retain the Numeric values from the column (originally in Character data type). Tried to search for this problem in our community couldn't achieve any relevant information about it.
Picture01 - OriginalColumnFormat - Screenshot of Column's original data type
Picture02 - ColumnafterChangingDatatype- Screenshot of Column's after changing the data type to Numeric.
Thanks in Advance...