Scandic letters don't work in Uipath despite working in other applications

[RPA_tester]

Hi all,

I wonder, if anyone has faced this sort of a problem before. I have an input file that is a csv and has Scandic letters like “ä” and “ö”. I managed to get Uipath to (mostly) read them right by first opening the csv files in notepad and then storing them in ANSI-format.
This makes the Scandic letters work in the other applications (Excel, notepad) and generally in Uipath. However there is one file, where the scandics are always broken when read with Uipath.

In the other apps the value that is being read from this file is “lisä”, but uipath always reads it as “lis�”. I tried forcing the scandics to their proper form with String.replace(“=E4”,“ä”), but it doesn’t seem to be working.

The workstation’s language setting is Finnish.

Any ideas? It might be something to do with the original file, but I would welcome any hints or tips.

[HareeshMR (Hareesh Madasi)]

You need to change the encoding of the text to get the actual value @RPA_tester

here is the reference post for the same

Problem with encode

@Guille267 I’m not sure this will solve your issue, but give a try Read text file and store the data in a string variable Then use assign activity to convert the standard characters to utf-8 Then write it back to the text file and check if it is written as expected The assign command is system.Text.Encoding.ASCII.GetString(system.Text.Encoding.UTF8.GetBytes(str))

[bcorrea (Bruno Correa)]

Use ISO-8859-15 for Finnish for better support and also for Euro symbol support.