Ability to export values as formatted for .CSV

HeidiKing
HeidiKing
in Integration and Extensibility Ideas

As a user, I need to be able to export data in the format I have set instead of a standardised format when exporting as .CSV.

 

For example, I want to be able to export

 

  • Large numbers - The option to export "1,000,000,000,000" rather than "1.0E12"
  • Small numbers - The option to export "0.00001" rather than "1.0E-5" 

My data feeds other systems that do not accept scientific notation and I currently have to create external workarounds for this

Tagged:
15
15 votes

Delivered · Last Updated

Comments

  • Miran
    Miran
    Status changed to: Delivered
  • Gwen.pryor
    Gwen.pryor
    Status changed to: Delivered
  • dafinkapancheva
    dafinkapancheva

    Model builders and workspace administrators can now select an option to export formatted numbers for unformatted file types: text, CSV, unformatted XLS, and XML. This makes it easier to use the data in other applications. The exported numbers match the number of decimal places set up for the line item, and use "." as the decimal indicator. No thousand separator is used, and custom units and currency symbols are not exported. 

Get Started with Idea Exchange


See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!



Categories