This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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.
Experienced users may have found their way around the trap doors and might be happy with those issues. But for new users, fixing such issues could improve the start with Jmp significantly: no need to learn any workaround...
> 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. To load such files there are several workarounds:
a) use a specific addin that does the magic
b) load with commas, select the wrong columns and use standardize attributes to replace comma with point and convert the characters to strings
c) go to the preferences, change the decimal separator to comma, load the file, go to the preferences and switch the decimal separator back to point *)
*) don't forget!!!
d) load the csv file in Excel (specify decimal separator in the GUI - save it as xlsx and open in Jmp
e) Jmp18: use python/panda
f) load text file without parsing it, replace all commas with points, let Jmp parse it with point as decimal separator.