nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Make decimal separator an option

pauldeen

I would like to be able to specify decimal separators as comma or period on a per table basis. So decouple it from my local computer settings. Reason being that I import data from all around the world and export to people around the world as well.

Status: Acknowledged

Comments

gerd

Hi Paul,

not sure if you came across the below wish. It's "In Development" (see comments) and goes in the same direction as your wish. There, a developer suggested to implement a field in which to enter the decimal sign which can be independent of the system settings or display language. This would work well for me, and I'm looking forward to it. I believe your idea is to add such a field to File -> Open, rather than the main preferences?

https://community.jmp.com/t5/JMP-Wish-List/JSL-command-to-Get-and-Set-the-Display-Language-in-JMP/idi-p/241372

Gerd

pauldeen

I like the plan mentioned in the post, if that can also be added to all file import dialog's we would have maximum robustness. It could probably be a table property (similair to a column property) for data stored in JMP tables.

Ryan_Gilmore

We are archiving this request. If this is still important please comment with additional details and we will reopen. Thank you!

hogi

@Ryan_Gilmore : please reopen the task.

Quite many people already had this wish. What is the reason that it cannot be implemented?

Are there some legal restrictions why it is not possible to add this option?

It would help a lot of people in countries where comma and point are equally used as decimal separators.

sure:

- Some users don't need this feature.

- There are workarounds.

SamGardner

We will reopen this and take it under consideration.

Sarah-Sylvestre

hogi

thanks

hogi

edit:
added a link to Caution: Places where Jmp does something unexpected

+1 on adding this option ASAP.

First-time users struggle a lot not finding this option within the import settings. Any modern language has this option (see pandas doc).

hogi

The JMP workflow is great - but for some users (maybe even some users in the US?) it starts with a severe hiccup. No possibility to interactively define the decimal separator per file import.

Jmp Users: we need it.

Jmp: really. Why?

Jmp Users: we need it, please!

Jmp: archived

...

The history of this ticket is surprising indeed. This is one common problem when loading text data.

hogi

Experienced users may have found their way around such trap.
But for new users, fixing such issues could improve the start with Jmp significantly!

hogi

To specify the issue:

> 90% of our data uses point as decimal separator.
So I urge my colleagues to specify point in the preferences as decimal separator.
Some files use comma as decimal separator.
There are many cool features in JMP - but there is no setting in JMP to specify the decimal separator for open and MFI . Neither via JSL, nor via the GUI.

hogi

One of the features which ARE available in Minitab:

@Sarah-Sylvestre, any update on this feature request? Thanks

hogi

I was surprised to see that under some conditions it's possible to open files with point and comma as decimal separators.

So I invested some time to create an overview:txt import - point and comma ?

Open():

MFI: