Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Woojtek_96
Contributor III
Contributor III

Replace special characters

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

1 Solution

Accepted Solutions
atoz1158
Creator II
Creator II

Hi

 

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

 

View solution in original post

4 Replies
atoz1158
Creator II
Creator II

Hi

 

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/Replac...

Regards

Adrian

Woojtek_96
Contributor III
Contributor III
Author

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

atoz1158
Creator II
Creator II

Hi

 

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

 

Woojtek_96
Contributor III
Contributor III
Author

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

Thank you very much!