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.

[FN]

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:

hogi_0-1718103928694.png

[FN]

@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: