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>>

Attachments

Library

Quick Reference