Hello Appian Community,
I am currently working with Process HQ reports, and when exporting the data, the files are automatically downloaded in CSV format.
I have two questions regarding this export:
Some fields that are numeric are being exported as text format. Is there a way to ensure they are downloaded directly as numeric values instead of text?
In some cases, exported numbers include a strange prefix character (for example: $~118.331.052.083.617,56). Is there a recommended configuration or workaround to prevent these characters from appearing?
$~118.331.052.083.617,56
Any guidance or best practices would be greatly appreciated.
Thank you in advance for your support.
Regards,
Monica Vela,
Discussion posts and replies are publicly visible
In a CSV, there is no such thing like data types. Everything is just text, and data type interpretation is up to the application you use when opening the CSV.
I suggest to open the CSV in a text editor like Notepad++ and check the values there.