'removing speciacl characters from teradata coloumn
how to remove special characters from Teradata columns. I am having columns values other than characters A-Z and numbers 1-9, how to remove theses column values as we don't know the exact special character. Can any one share the command for it?
Solution 1:[1]
You can use a regular expression, '[^0-9a-z]' to find characters which don't match a list of characters:
regexp_replace(col, '[^0-9a-z]', '', 1, 0, 'i')
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | dnoeth |