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?
Thank you Stefan for your reply.
I meant this character "~". When the amounts are large, the report shows values like: $~118.331.052.083.617,56. Since this character appears before the number, when converting the value from text to numeric, it is not recognized and calculations cannot be performed. (The amounts are expressed in COP – Colombian Pesos).
Do you see this in Excel or in the text editor?
In Excel, we are currently in the stabilization phase, and the client is downloading their information to perform calculations
Excel changes the data when reading a CSV. You have to check the data in a text editor.
If the data in the text editor is correct, the problem is with Excel, and there is nothing Appian can do about.