I would very much appreciate if the import Wizard for XLS-files would allow to specify how to read the data. As you know, in Germany (and elsewhere) the use of comma instead of point is widespread. If reading in such a file, it looks as follows:
So JMP recognizes all, buccal, lingual etc. are numerical variables, but represented with a comma, and hence I get just missing values. A workaround is to change the preferences (under “windows-specific) and remove the check of the “use JMP language rather…” as indicated below:
However, for other data where the representation in XLS is with decimal point, I need to convert back. I’d love to be able to check/uncheck this in the import wizard, or be able to specify what the decimal separator should be in this data set, that would simplify my life substantially.
Michael Meyners meyners.m@pg.com Kronberg Plant Germany
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />Comment from JMP developer:
By default JMP will use the system settings and recognize the decimal separator as specified there. Adding an option on every import dialog and JSL statement where you might import a file is not practical.
