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.
Accept
Reject
Preferences
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

Export to CSV/TSV more options on number formatting

Status: Acknowledged Submitted by on ‎05-23-2018 01:29 AM
2 Comments (2 New)

I regularly need to export some JMP tables into CSV or TSV format. My computer/Windows uses the typical German locale settings, e.g. comma as decimal separator instead of period. If I do not explicitly select "Use JMP language rather than System locale settings..." and settings the Display Language to "English", the CSV/TSV file will export numerical values as "3,14159" (including the quotation marks). This sort of export makes it difficult to import the file into other tools that prefer the typical format 3.14159 (period as decimal separator and not quotation marks).

It would be really helpful, if I could continue to use JMP with e.g. German user interface and also numbers expressed in the operating system's locale setting within JMP but having more options on exporting the data to avoid the above issues.

 

Björn

See more ideas labeled with:
2 Comments
AuroreA
Level I
‎01-23-2019 03:07 AM
‎01-23-2019 03:07 AM

For me, it would be also very helpful to have a parameter in the OPEN function to control the decimal separator!

Sarah-Sylvestre
Staff
Staff
‎12-14-2022 11:47 AM
‎12-14-2022 11:47 AM
Status changed to: Acknowledged

Hi @bjoern_arnold, thank you for your suggestion! We have captured your request and will take it under consideration.