Removing non-english words in the dimension

[LovelyKrishna]

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.

[Taoufiq_Zarra]

@LovelyKrishna 

you can use

=keepchar(Field,'aAbBcCdDeEfFgGhHiIjJkKlLmMnNoOpPqQrRsStTuUvVwWxXyYzZ0123456789')

as dimension, Field is your Dimension Name

[LovelyKrishna]

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