topic In-data letters needs formatting in QlikView https://community.qlik.com/t5/QlikView/In-data-letters-needs-formatting/m-p/230172#M82036 <HTML><HEAD></HEAD><BODY><P>Thank you very much.</P></BODY></HTML> Tue, 26 Apr 2011 20:37:06 GMT 2011-04-26T20:37:06Z In-data letters needs formatting https://community.qlik.com/t5/QlikView/In-data-letters-needs-formatting/m-p/230170#M82034 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>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?</P><P></P></BODY></HTML> Tue, 26 Apr 2011 18:05:08 GMT https://community.qlik.com/t5/QlikView/In-data-letters-needs-formatting/m-p/230170#M82034 2011-04-26T18:05:08Z In-data letters needs formatting https://community.qlik.com/t5/QlikView/In-data-letters-needs-formatting/m-p/230171#M82035 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can use mapsubstring. Basically you are going to create a table on script for this (can read it from excel too)</P><P>Please, check this post:</P><P><A href="http://community.qlik.com/blogs/qlikviewblogs/archive/2009/01/09/using-mapsubstring-to-edit-strings.aspx">http://community.qlik.com/blogs/qlikviewblogs/archive/2009/01/09/using-mapsubstring-to-edit-strings.aspx</A></P></BODY></HTML> Tue, 26 Apr 2011 18:11:21 GMT https://community.qlik.com/t5/QlikView/In-data-letters-needs-formatting/m-p/230171#M82035 erichshiino 2011-04-26T18:11:21Z In-data letters needs formatting https://community.qlik.com/t5/QlikView/In-data-letters-needs-formatting/m-p/230172#M82036 <HTML><HEAD></HEAD><BODY><P>Thank you very much.</P></BODY></HTML> Tue, 26 Apr 2011 20:37:06 GMT https://community.qlik.com/t5/QlikView/In-data-letters-needs-formatting/m-p/230172#M82036 2011-04-26T20:37:06Z