REGEXP_REPLACE
970021Mar 22 2013 — edited Mar 23 2013How do I remove all characters from a string except for decimal numbers?
Examples:
if string = 'sdfdsf 1.4ds dsfs / ', I want to return '1.4'. I have this to remove all characters, but it also removes the dots:
SELECT REGEXP_REPLACE(col1, '[^0-9]+', '') FROM table1;