topic Skip special characters in QlikView

Skip special characters

harleen_singh — Fri, 27 Jul 2012 07:04:48 GMT

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

Re: Skip special characters

giakoum — Fri, 27 Jul 2012 07:09:36 GMT

KeepChar(s1 , s2)

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

Example:

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

Re: Skip special characters

Anonymous — Fri, 27 Jul 2012 07:15:05 GMT

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

This removes the unwanted characters

Re: Skip special characters

Fri, 27 Jul 2012 08:13:45 GMT

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.