Home Page for the TeradataForum
 
https:

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020