Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Am new to Qlikview. Could you explain KeepChar and PurgeChar?

Could you explain Keep Char and Purge Char?

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Hi,

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

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted

Please do Practice creating Inline Table?

Load *, KeepChar(FieldName, '!@#123') as KeepChar,PurgeChar(FieldName, '!@#123') as PurgeChar  Inline [

FieldName

1234ABCD

!@@#$ABCD1234

];

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Master II
Master II

Pandiri priyanka,

KeepChar() returns a string consisting of the first string, 'text', less any of the characters NOT contained in the second string, "keep_chars".

KeepChar(text, 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').

PurgeChar(text, remove_chars)

1.JPG