Discussions

Expand all | Collapse all

Exporting to CSV questions

  • 1.  Exporting to CSV questions

    Posted 07-01-2021 15:55
    Is it possible to export a numeric field to a CSV, and have it show the numbers with a negative sign, instead of with parentheses?

    The only way I can think to do it is to use a formula text field (ToText([Amount]), and export that to the CSV. Works like a charm, except then in the report, it doesn't total that row because of course, it's text.

    Any ideas to show a report with totals, but on export to csv, use a text version of the numeric field?

    ------------------------------
    Mike Tamoush
    ------------------------------


  • 2.  RE: Exporting to CSV questions

    Posted 07-01-2021 16:46
    That should be a setting in the program you're using to open the CSV. I downloaded a test file a moment ago and opened it in Excel to see this:



    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quickbase Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------