Removes all characters from a string that are not letters, numbers, 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:

zzQUESTIONMARKzz

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

 

Column reference example:

Output: Returns the value in the MyName column value with all non-alphanumeric characters removed. 

String literal example:

Output: Returns the string: Héllõ Wõrlds.

Wildcard example:

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


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

column_string

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