topic Re: Replace special characters in QlikView

Replace special characters

Woojtek_96 — Thu, 04 Jul 2019 12:48:06 GMT

Hi all.

Is there a possibility to replace characters in cell? For example i want to change particular characters like Ą -> A, Ć -> C, Ę->E, Ń -> N etc (i was looking for function to do this but google only shows me a threads with remove instead of replace)

Thanks for help

Wojtek

Re: Replace special characters

atoz1158 — Thu, 04 Jul 2019 13:15:48 GMT

There is a Replace() function below is the link to help page

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/StringFunctions/Replace.htm

Regards

Adrian

Re: Replace special characters

Woojtek_96 — Fri, 05 Jul 2019 07:29:54 GMT

Yes, function replace could be useful in this case but can i replace 2 or more characters?

for example if i have string: aąbć and want to change it to: aabc? Replace('aąbć','ą',a' & 'ć','c') dont work

Re: Replace special characters

atoz1158 — Fri, 05 Jul 2019 08:53:48 GMT

What you would need to do in that case is

Replace(Replace('aąbć','ą','a'), 'ć','c')

If the number of replacements is not that big then this nesting of the Replace function should work fine.

Regards

Adrian

Re: Replace special characters

Woojtek_96 — Fri, 05 Jul 2019 09:45:14 GMT

I have to replace 7 characters but i will try this option.

Thank you very much!