Skip special characters

[harleen_singh]

Hello,

               Is there is any function in Qlikview which skip special characters?

From a string, I just want to read only digits 1 to9 and A-Z from a string

thanks

Lavi

[giakoum]

KeepChar(s1 , s2)

Returns the string s1 less all characters not contained in string s2.

Example:

keepchar ( 'a1b2c3','123' ) returns '123'

[Anonymous · Accepted solution]

Or use the opposite, PurgeChar(String, 'Characters to exclude')

This removes the unwanted characters

[#4]

Use KeepChar or PurgeChar function, both will help you in skipping special charecters. Using Keepchar you can keep (e.g. 0-9 and Aa-Zz) required charecters and using purgechar you can actually purge/skip unwanted charecters.

Thanks,

Amey.