In-data letters needs formatting

[#1]

Hi,

I have some data where Swedish and Norwegian letters are replaced by other letters. For example Ö is replaced by √ñ. Is there a way to format this easily?

[erichshiino · Accepted solution]

Hi,

You can use mapsubstring. Basically you are going to create a table on script for this (can read it from excel too)

Please, check this post:

http://community.qlik.com/blogs/qlikviewblogs/archive/2009/01/09/using-mapsubstring-to-edit-strings....

[#3]

Thank you very much.