Comma to dot in a table column without changing preferences

HenningWeiss — Sun, 11 Jun 2023 11:07:44 GMT

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

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

ian_jmp — Tue, 03 Nov 2020 11:58:09 GMT

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

HenningWeiss — Tue, 03 Nov 2020 12:54:05 GMT

Hello Ian,

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

I accepted as answer.

Best, Henning

topic Comma to dot in a table column without changing preferences in Discussions

Comma to dot in a table column without changing preferences

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

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