I have a variable that looks as follows. It is in character format [Length - 9, Format - $9., informat - $9.] with * in some observations. I would like to know how I can convert this to numeric values?
_09015C_1_VALUE
1.28
1.52 *
1.50 *
1.58 *
1.74 *
1.18
1.01
1.61 *
I have tried these steps, but it didn't work
*SC=_09015C_1_VALUE*1;
SC=input(_09015C_1_VALUE,9.0);