Removes from a string all characters that are not alpha-numeric, accented Latin characters, or whitespace.

NOTE: Non-Latin letters are also removed.

Tip: This function also removes common punctuation, such as the following:

. , ! & ?

To preserve these characters, you might replace them with an alphanumeric text string. For example, the question mark might be replaced by:


After the function has been applied, you can replace these strings with the original values.


Column reference example:

derive type:single value:REMOVESYMBOLS(MyName)

Output: The value of the MyName column value with all non-alphanumeric characters removed. 

String literal example:

derive type:single value:REMOVESYMBOLS('Héllõ, Wõrlds!?!?')

Output: The string Héllõ Wõrlds is written to the new column.

Wildcard example:

set col:* value:REMOVESYMBOLS($col)

Output: Strips all non-alphanumeric or space characters from all columns in the dataset.

derive type:single value:REMOVESYMBOLS(column_string)

ArgumentRequired?Data TypeDescription
column_stringYstringName of the column or string literal to be applied to the function


Name of the column or string constant to be trimmed of symbols.

Required?Data TypeExample Value
YesString literal or column referencemyColumn

Example - String cleanup functions together