Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Could you explain Keep Char and Purge Char?
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.
Regards,
Kaushik Solanki
Please do Practice creating Inline Table?
Load *, KeepChar(FieldName, '!@#123') as KeepChar,PurgeChar(FieldName, '!@#123') as PurgeChar Inline [
FieldName
1234ABCD
!@@#$ABCD1234
];
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)