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:
After the function has been applied, you can replace these strings with the original values. |
Column reference example:
removesymbols(MyName) |
Output: Returns the value in the MyName column value with all non-alphanumeric characters removed.
String literal example:
removesymbols('Héllõ, Wõrlds!?!?') |
Output: Returns the string: Héllõ Wõrlds.
Wildcard example:
removesymbols($col) |
Output: Strips all non-alphanumeric or space characters from all columns in the dataset.
removesymbols(column_string) |
| Argument | Required? | Data Type | Description |
|---|---|---|---|
| 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.
'Hello, World').| Required? | Data Type | Example Value |
|---|---|---|
| Yes | String literal or column reference | myColumn |