Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I would like to remove the non-english words in the dimension/field (non-english words mean not special characters and it is other languages).
Can you please help me how to get rid of the non-english words in the dimension using qlik functions or any other alternative options if possible.
Thanks in Advance.
you can use
=keepchar(Field,'aAbBcCdDeEfFgGhHiIjJkKlLmMnNoOpPqQrRsStTuUvVwWxXyYzZ0123456789')
as dimension, Field is your Dimension Name
Thank you Taoufiq for your quik response, But in my case there are some special characters also and in that case i would specify all the special characters so we are not sure about the special characters what are all they.
I will use your solution if special characters are confirmed.
Thank You....