Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 27 May 2005 @ 13:51:27 GMT


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


Subj:   Re: Trim Function for multiple characters
 
From:   Victor Sokovin

  Can you provide an example stating what is that you are looking for? Otherwise you can refer the SQL reference volume5 for more details on string functions. I'm sure you will be able to figure out how to do it.  


I think what the OP means is the following:

     "LTRIM(char,[set])

Removes characters from the left of Char, with all the leftmost characters that appear in Set removed. Set defaults to a single blank. Oracle begins scanning Char from its first character and removes all characters that appear in Set until reaching a character not in set and then returns the result."

It is rather "advanced", isn't it?

I think the standard recommendation here would be to write a User Defined Function (UDF). Easier to say that than to follow the advice, especially for a beginner.

The good news is that NCR have provided a set of UDFs for Oracle functions. They are available for download from the NCR site. I cannot recommend them personally (not that they need to be recommended) because I have never worked with them but they might be worth checking out at least as examples of what is possible in terms of extension of standard TD functions.


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: 23 Jun 2019