Archives of the TeradataForum

Message Posted: Wed, 26 Apr 2006 @ 17:59:33 GMT

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

I had John put a UDF out in the Library that I wrote specifically for this purpose. It's called nthValue and you can find it on the forum website under Library and then UDF Library.

It's written to where you supply the delimiter that the values are separated by. If you put an asterisk(*) after the delimiter it will treat repeating delimiters as one. This will handle the multiple spaces that can be found between some of the values in the logonsource.

Robert Meunier

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