Archives of the TeradataForum

Message Posted: Wed, 13 Feb 2013 @ 17:18:07 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Need to filter Numeric value from Alphanumeric string

From:		Dieter Noeth

Anomy.Anom wrote:

I need to filter out numeric value from alphanumeric string

Example: if String is str55555ingd4w5i6th8digit

then output I need as 555554568

This is usually done with a UDF stripping of the chars.

If you already got otranslate on your system you could use it, too:

     otranslate(x,otranslate(x, '0123456789',''),'')

Dieter


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Archives

2013 Indexes

Last Modified: 15 Jun 2023