329167_en-US

liliconcom

Comma to dot in a table column without changing preferences

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

AnalyticsData TableGraphicsRe: Comma to dot in a table column without changing preferences

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

 

Re: Comma to dot in a table column without changing preferences

Hello Ian,

 

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

I accepted as answer.

 

Best, Henning