Tags for extracting text
How to extract numbers from string using teradata functions, operators?
I have a column that has both numbers and texts in the fields. Examples: xyz 120 abc lmnop xy 120 120 Null ?/ 567 abc .... 233 As you can see the fields can have numbers, texts, special chacters, null values, etc. If there is a no numbers in a field I want to return null for that.
teradata sql extract numbers from string extracting text numbers