Append to CSV special characters

Help Studio
1

Hey guys,

when I use the activity Append to CSV special characters like Ä,Ö,Ü are not formatted correctly as you can see in the screenshot below. I tried different encodings like UTF-8 but it’s not working.

Thanks in advance! Best regards, Alisa

grafik

2

we would touch the encoding and using a different.
Here the existing CVS (on which you append) will trigger the needed encoding

With notepad++ editor we can a little bit explore whichone is in use

3

Hi,

If you use old version Excel, it’s necessary to use specific encoding (such as Windows1252 etc)
The following sample may help you.

image
image1028×608 30.1 KB

Sample20240124-1.zip (3.0 KB)

Regards,

4

Hey! I tried it but it says that Windows1252 is not a supported encoding name…
grafik

5

Hi,

Can you try to add the following InvokeMethod activity in my sample?

image

This calls the following method

System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance)

Sample
Sample20240124-1.zip (3.0 KB)

Regards,