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.
Thank you Stefan.
Do you know about topic 2?
2. 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?
Which character do you mean? Do you see it in the CSV in the text editor? What does "in some cases" mean?