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.
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)
|column_string||Y||string||Name 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 Type||Example Value|
|Yes||String literal or column reference|