| D toc |
|---|
| Excerpt |
|---|
Removes all characters from a string all characters that are not alpha-numericletters, numbers, accented Latin characters, or whitespace. |
...
| Tip | ||||
|---|---|---|---|---|
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. |
| D s lang vs sql |
|---|
| D s | ||
|---|---|---|
|
Column reference example:
| d-codelang-syntax | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| REMOVESYMBOLS
| |||||||||
removesymbols(MyName) |
Output:
...
Returns the value
...
in the MyName column value with all non-alphanumeric characters removed.
String literal example:
| d-codelang-syntax | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| REMOVESYMBOLS
| |||||||||
removesymbols('Héllõ, Wõrlds!?!?') |
Output:
...
Returns the string: Héllõ Wõrlds
...
.
Wildcard example:
| d-codelang-syntax | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| REMOVESYMBOLS
| |||||||||
removesymbols($col) |
Output: Strips all non-alphanumeric or space characters from all columns in the dataset.
| D s | ||
|---|---|---|
|
| d-codelang-syntax | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| REMOVESYMBOLS
| |||||||||
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 |
...
