Discussion Board for collaboration related to QlikView App Development.
Could you explain Keep Char and Purge Char?
KeepChar(Field,Characters) - As a name suggest it is used to keep the specified characters from the supplied field.
Purgechar(Field,Characters) - As a name suggest it is used to purge the specified charcters from the supplied field.
For more help check below links.
String functions ‒ QlikView
Please do Practice creating Inline Table?
Load *, KeepChar(FieldName, '!@#123') as KeepChar,PurgeChar(FieldName, '!@#123') as PurgeChar Inline [
KeepChar() returns a string consisting of the first string, 'text', less any of the characters NOT contained in the second string, "keep_chars".
PurgeChar() returns a string consisting of the characters contained in the input string ('text'), excluding any that appear in the second argument ('remove_chars').