sql - Extracting numeric value in teradata -

i have column varchar data type.some sample values

abc 56 def 34 ghi jkl mno 78 

i wanted numeric values only, like

56 34 78 

thanks in advance.

if you're on td14 can use regular expression:

regexp_substr(col, '[0-9]+') 

before might have otranslate udf, there's old trick remove character list of wanted ones:

otranslate(col,otranslate(col, '0123456789',''),'')