Even though I'm from EU I always use "." as my decimal separator, so my example will be using "," as "wrong" decimal. Starting table:
![jthi_0-1659368979989.png jthi_0-1659368979989.png](https://community.jmp.com/t5/image/serverpage/image-id/44439iB56DEDD667FCF19A/image-size/medium?v=v2&px=400)
Recode Column 1 to capture the script
![jthi_1-1659368993796.png jthi_1-1659368993796.png](https://community.jmp.com/t5/image/serverpage/image-id/44440i00D520E0C6FE5BB5/image-size/medium?v=v2&px=400)
![jthi_2-1659369003220.png jthi_2-1659369003220.png](https://community.jmp.com/t5/image/serverpage/image-id/44441i47547F5102B5BA25/image-size/medium?v=v2&px=400)
![jthi_3-1659369009393.png jthi_3-1659369009393.png](https://community.jmp.com/t5/image/serverpage/image-id/44442iFE15D0BB0FD7BDB7/image-size/medium?v=v2&px=400)
![jthi_4-1659369019962.png jthi_4-1659369019962.png](https://community.jmp.com/t5/image/serverpage/image-id/44443i78A4D28F30A88915/image-size/medium?v=v2&px=400)
From Enhanced Log
![jthi_5-1659369041392.png jthi_5-1659369041392.png](https://community.jmp.com/t5/image/serverpage/image-id/44444iC66C0337B14D404C/image-size/medium?v=v2&px=400)
And finally script it
Names Default To Here(1);
dt = New Table("Untitled 3",
Add Rows(2),
New Column("Column 1", Character, "Nominal", Set Values({"1.1", "1.2", "1.2E-3"})),
New Column("Column 2", Character, "Nominal", Set Values({"2,1", "2,3", "1.2E3"}))
);
dt << Begin Data Update;
For Each({col_name}, dt << Get Column Names("String"),
dt << Recode Column(
AsColumn(col_name),
{Substitute(_rcNow, ",", ".")},
Update Properties(1),
Target Column(As Column(col_name))
);
Column(dt, col_name) << Set Data Type("Numeric");
Column(dt, col_name) << Set Modeling Type("Continuous");
);
dt << End Data Update;
-Jarmo