cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

Make decimal separator an option

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.

16 Comments
FN
Level VI

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

 

 

hogi
Level XII

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
Level XII

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
Level XII

One of the features which ARE available in Minitab:

hogi_0-1718103928694.png

 

FN
Level VI

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

hogi
Level XII

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():

hogi_0-1735808920885.png

 

MFI:

hogi_1-1735808946844.png