Dear all,
I do need to write from .xlsx to .csv. But with write csv activity, it is written in UTF-8 and the system is not able to read it.
Do you know how can i write a csv with comma delimited?
Many thanks!
Dear all,
I do need to write from .xlsx to .csv. But with write csv activity, it is written in UTF-8 and the system is not able to read it.
Do you know how can i write a csv with comma delimited?
Many thanks!
Hi,
Write CSV activity have Encoding in Properties:
Just change the encoding:
Hi @Adrian_Star , do you know the encoding I should use?
Thanks
You can use different types, eg.:
Unicode, UTF-7, UTF-8, UTF-16, UTF-32, ASCII
Try: Unicode
This is what is written in the csv:
But I need the information in each column, as the system does not recognize this excel alsoβ¦
Thanks
In my country column in csv is β;β separated. Try different separator for your country region eg. β,β