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

[Anonymous]

Could you explain Keep Char and Purge Char?

[kaushiknsolanki]

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

[Anil_Babu_Samineni]

Please do Practice creating Inline Table?

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

FieldName

1234ABCD

!@@#$ABCD1234

];

[Siva_Sankar]

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)