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.
I saw some forums that provide queries to address the problem but I those use SQL or Oracle functions, systax and it did not work in teradata. This forum provides a query on how to extract number from strings - http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/extracting-numbers-with-sql-server. However, the query does not work in teradata because it uses sql functions and operations. I am a beginner in the field so please help. Any comment would be very helpful. Thanks in advance!