Home Page for the TeradataForum

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


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020