Greetings,
i am having a following problem:
I need to export a file to .csv format with the field delimiter was semicolon (;) and comma (,) was decimal but the ouput is the oposite (File was excel)
I make this setup:
I define it in the beginning of the flow the delimiter was (;).
I put the data in a structure var from a aggregate then i run the action ExportRecordListtoCSV with the config setup was the delimiter (;).
After that i pass the output received was text to a BinnayData to be download. i do a replace of dot (.) to comma (,)
But when the file is download and i open via excel the configuration i made didnt apply/worked...
The semicolon stay and the comma dissapear in this case are used was cell separator.
Did someone have this kind of issue and come up with a solution?
Hello @Bruno Andre,
When you open a CSV file in Excel, Excel automatically formats the file.
Option 1: So to open the csv file correctly in Excel, try the following steps:
You should now see the semi colon delimiter working.
Option 2: You can add a single quotation in front of each value as suggested by Wei in this post.
Hope this helps,
Regards,
AJ
Hello Bruno
Greetings!
I am not sure if that's work but you can try with the ASCII Value 59 which determine ;
You can write Chr(59) and try. Or share the OML if possible.
Hi AJ and Manish Gupta ,
I come up with a solution for this issue when i assign the values from the aggregate to the var record and do the replace there it seens that in txt file the valeue come in double quotes and when you open it in Excel the comma appear between decimal values, i didnt use the Excel option 1 because i am not the end user who have the config.
But thank you very much with our help i sort the issue