Hey,
I’m using the Read CSV activity on a csv file and append to csv. The csv have special characters ö,ä,ü and ß , The new CSV replaces these characters with some question mark character.
I set the encoding on the Read CSV activity to utf-8 already.
1 Like
ppr
(Peter Preuss)
October 21, 2019, 12:38pm
2
In such cases a check e.g. with notepad++ of the csv file can help to check
for character set to use
encoding issues in the csv
then the read csv activity should be configured to the encoding set as applied in csv file
In case of corruption or Schmutzzeichen already present on the csv a correction is to plan (manually, tool based)
i cant install notepad++ on my workplace
ppr
(Peter Preuss)
October 21, 2019, 12:50pm
4
i cant install notepad++
alternate options could be:
portable version of notepad++
checking the CSV file outside of machine on anoher machine
doing some prototyping with Powershell by readin / write out the csv and trying with different encodings
in case there are only this 24 values recreate manually a new CSV and get control on the used character set
1 Like
Topi
(Topi Asikainen)
October 21, 2019, 12:54pm
5
Have you tried setting the encoding to “ISO-8859-1” instead of UTF-8 ?
br,
Topi
1 Like
ok portable worked thx
The CVS file A “Encode in Ansi”
The CVS file C “Encode in UTF-8-BOM”
ok it worked
In Read and Append → Encoding “iso-8859-15”
3 Likes
ppr
(Peter Preuss)
October 21, 2019, 1:37pm
9
@BjoernMikolajewski great news. Do you want to close topic with the solution flag as it is working?
ppr
(Peter Preuss)
October 21, 2019, 2:38pm
11
@BjoernMikolajewski
As you are the author of this post you can flag the helping information with the solution flag:
So others members:
can see that it is solved and invest their time on open topics
researchers can easier identify the working things
1 Like
system
(system)
Closed
October 24, 2019, 2:38pm
12
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.