clean

Syntax:

Value String  clean(String str, List Identifier characters)

Description:

Removes groups of characters listed in characters from str.

Options:

Identifier characters:
digitDigits (0,1,2,3,4,5,6,7,8,9)
lowLowercase letters (a,b,c,...,x,y,z)
capCapital letters (A,B,C,...,X,Y,Z)
punctPunctuation (! @ $ % & ...)
unprintUnprintable characters

Examples:

($a1:$a5) = clean($self,punct,digit)
Before:
AB C
1"Hello World!"
2"crt34..A43"
31one2two3
44.56
5"XSheet"
61641
After:
AB C
1"Hello World!"
2"crt34..A43"
31one2two3
44.56
5"XSheet"
61641
($d1:$d10) = format($b,{0:00.0})