User Community
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: 
  • DownloadSemiconductor Toolkit: Tools to create wafer maps, add wafer geometry to graphics, explore die defects & compare wafers.
  • Discovery Summit 2026: Early User Edition - September 23-24.Register. It's free.
  • Use JMP Clinical with CDISC-compliant data. Review studies, ID safety and efficacy signals & communicate findings with interactive graphics. Register to see how. Aug. 27, 2 pm US ET.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
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

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.