Get text and write to a datatable cell - non-English characters

Help Studio
, ,
1

Hello, the below is the text the bot gets from the UI element:
“The website belongs to Vässla, a company that develops and sells electric bikes and scooters. The focus is on their latest product, the Vässla Pedal, an electric bike that is said to be fun to ride and built to last. Customers can pre-order the bike and it will be delivered in May 2023. The website also showcases accessories and deals for their products, and has a section for customer stories and news. The website is in Swedish and uses the SEK kr currency.”

“ä” is a letter in the Swedish alphabet
when the bot writes this text to excel (datatable), the “ä” just disappeared and it became “V ssla” in excel, what can I do to get “ä” to show up as it is? also this is not just limited to “ä”, in general I need to show any special letter if it appears

2

is it Excel or CSV opened in EXCEL?

3

it is in Excel thanks

4

we assume it is stored within a variable. Just use the immediate panel and dumpout the variable content:
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

the motivation is:

  • checking where any character encoding issue / conversion / damage / loss is happening

Similar to ä from Sweden, we do handle Umlauts as well in our local Lang like ÄÖÜßäöü in general it is working with datatable / excel.

Maybe you can share some screenshots from your modeling as well. Thanks

5

Thanks, the video is very helpful.

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.