Write CSV in comma delimited, no UTF-8

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! :slight_smile:

Hi,
Write CSV activity have Encoding in Properties:
Just change the encoding:

image

1 Like

Hi @Adrian_Star , do you know the encoding I should use?

Thanks :slight_smile:

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. β€œ,”