Archives of the TeradataForum

Message Posted: Wed, 26 Apr 2006 @ 12:42:47 GMT

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

Hi

These are some logonsource string examples out of which I need to extract the 4th last word like WORD1, WORD2, WORD3

the separators being 'space character'

     (TCP/IP) 0484 1.02.30.1 DBC      4091  WORD1  APPL1  01 LSS
     (TCP/IP) 08A8 234.189.12.47  AAA.BBB.CCC.NET   3176  WORD2 APPL2  01 LSS
     (TCP/IP) 10C2 68.28.617.14  AAA.BBB.CCC.NET   2996  WORD2 APPL3  01 LSS
     (TCP/IP) 04AD 153.112.14.52  AAA.BBB.CCC.NET   2884  WORD2 APPL4  01 LSS
     (TCP/IP) 0F55 111.186.14.52 ABCD     14722  WORD3  APPL5  01 LSS

Is there a way in which we can find the index of the 4th space character in a string.

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