DELETE_CHARACTERS
Description
DELETE_CHARACTERS
returns a string with the characters defined in the match string removed.
Supported input column types: STRING
Output column type: STRING
Syntax
DELETE_CHARACTERS ( table.column, match_string )
Match string
A match string may be begin with a ^ to invert the matching characters. The remaining characters either specify single characters or character ranges to remove. A character range is specified by the the lower and upper character, separated by dash (-).
NULL handling
If the value is NULL, the result is NULL as well. Additionally, strings with an incomplete unicode character at the end are mapped to NULL
Examples
[1] Delete ',' and '.'. | ||||||||||||||||||
| ||||||||||||||||||
|
[2] Delete all non ',' and '.'. | ||||||||||||||||||
| ||||||||||||||||||
|
[3] Delete upper case ASCII characters | ||||||||||||||||||
| ||||||||||||||||||
|