Csv export from Number (Float) with two decimals


#1

How do you export a csv with two decimal places from a Number (Float) field? I am trying to export a csv file with only two fields:

Field 1: a text field with numbers (no problem with this)

Field 2. a numeric field, that is: Number (Float). I need to round it (preferably up) to two decimal places and export as csv. For example: 1022.239586 should export to csv as 1022.24. Changing the output pattern to #.## has no effect on the export to csv. Do I have to convert the Number (Float) field to Text? Thanks


#2

You can do this with the File>Export>Custom Text Export window. For the numeric fields, change the str( function to the pattern( function, as shown here.

For details on using custom export, see: