Comma to dot in a table column without changing preferences

[#1]

Hi JMP community,

I would like to change comma to dot in a table column.

Boundary conditions:

- I am importing data with a script from my colleague - hence I cant change the script

- I get a table that contains the data as character in a column, I want to plot it

- the data contain a comma as decimal separator

- I dont want to change the overall settings of JMP, I only want to yield a new column that contains the data now with comma replaced by dot

-  I dont want to create a new script handling this in jsl (I have that), I want this to be possible with a few clicks from f.ex. the column properties. Its a standard action after all.

Any ideas or solutions out there!?

Thanks a lot! Looking forward to an approach.

Best, Henning

[#2 · Accepted solution]

If your character column were called "In", here's one way using a formula:

 

[#3]

Hello Ian,

thanks a lot for that quick reply and a good way to solve the problem.

I accepted as answer.

Best, Henning