Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 08 Jan 2004 @ 11:57:23 GMT


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


Subj:   Re: How to remove 'spaces' in a telephone number field using Teradata SQL
 
From:   Victor Sokovin

Mike,

You might want to do that kind of cleansing outside of TD, especially if the volumes are high like in CDRs. If you really are restricted to the database then one of the recent threads might be useful:

www.teradataforum.com/teradata/20031231_175516.htm


If the URL does not work, search for the thread entitled "Extracting characters from a string" in the Dec 2003 archive. The thread discusses a more generic case.

Yet another, and very new, way of doing this in TD would be to write your own UDF (User Defined Function) but I cannot recommend them because I still have to get my hands on them and gain more experience.


Regards,

Victor



     
  <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: 27 Dec 2016