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',''),'')

GHI