cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
hogi
Level XII

txt import - point and comma ?

MultiFileImport (MFI())
independent of the settings in the operating system and the settings in the preferences, 
text files with point as decimal separator can be imported, files with comma can't.

hogi_0-1735808250929.png

 

Open(...)
there are several settings in JMP that control whether txt files can be imported or not.
This is how it looks on my Win / JMP18.1.1 system:

hogi_6-1735808512059.png

(to make it easier to read I put the symbols for comma and point on top of each other)

Some findings:

  • There are some combinations where it's simultaneously possible to import txt files 
    with comma AND point as decimal separator : )
    No need to adjust the settings.
    hogi_7-1735808541813.png

  • For txt files with point as decimal separator - in general it's possible to import them.
    hogi_9-1735808607306.png

    ... with one exception: hogi_10-1735808632319.png, the combination of

    1)  English, Spanish ... display language (German is fine)
    2) JMP locale settings and
    3) decimal separator: comma
    hogi_2-1735756708267.png

  • If JMP displays data with comma as decimal separator, it's also possible to import such data:
    hogi_2-1735809028428.png
    ... just activate use regional settings in the preferences:
    hogi_0-1735756097053.png

     

  • An additional rule can be derived from this graph (top half):
    When JMP displays data with point as decimal separator it's not possible to import txt files with comma separator. 
    Just check your settings and compare with this overview. How about other languages ... does this rule hold in general?
0 REPLIES 0