| Excerpt |
|---|
Removes from a string all characters that are not alpha-numeric, accented Latin characters, or whitespace. |
| Info |
|---|
NOTE: Non-Latin letters are also removed. |
| 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: | Code Block |
|---|
zzQUESTIONMARKzz |
After the function has been applied, you can replace these strings with the original values. |
Column reference example:
| D code |
|---|
derive type:single value:REMOVESYMBOLS(MyName) |
Output: The value of the MyName column value with all non-alphanumeric characters removed.
String literal example:
| D code |
|---|
derive type:single value:REMOVESYMBOLS('Héllõ, Wõrlds!?!?') |
Output: The string Héllõ Wõrlds is written to the new column.
Wildcard example:
| D code |
|---|
set col:* value:REMOVESYMBOLS($col) |
Output: Strips all non-alphanumeric or space characters from all columns in the dataset.
| D code |
|---|
derive type:single value: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 |
column_string
Name of the column or string constant to be trimmed of symbols.
- Missing string or column values generate missing string results.
- String constants must be quoted (
'Hello, World'). - Multiple columns and wildcards are not supported.
| Required? | Data Type | Example Value |
|---|
| Yes | String literal or column reference | myColumn |
Example - String cleanup functions together
| Include Page |
|---|
| EXAMPLE - String Cleanup Functions |
|---|
| EXAMPLE - String Cleanup Functions |
|---|
|
