Archives of the TeradataForum

Message Posted: Mon, 04 Nov 2013 @ 14:42:15 GMT

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

In TD14 you can use REGEXP_REPLACE:

     sel REGEXP_REPLACE( 'ab%c*d$#', '[[:punct:]]','',1,0,'c') (varchar(16)) a

or oTranslate function:

     sel otranslate( 'ab%c*d$#','[]!"#$%&''()*+,./:;<=>?@\^_`{|}~-','')(varchar(16)) b

In other case you need to find or develop udf.

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