Displaying Umlauts / special characters in table from databricks query

💬 App Building
,
3

Hi @Paulo, thanks for the help!

Did not find that old thread during my search for some reason. Happy to report that it did work using the provideed formula in the transformer as follows:
"
let length = data.ItemName.length
let decodedArray = []

for (let i = 0; i < length; i++){
let str = data.ItemName[i]
let decoded = decodeURIComponent('%' + str.match(/.{1,2}/g).join('%'))
decodedArray.push(decoded)
}
data.ItemName = decodedArray
return data
"

Tried it with a map function first but that did not work for me. If you do have any suggestions to improve the transformer syntax, feel free to do so, otherwise, this is solved :slight_smile:

Thanks again!