Archives of the TeradataForum
Message Posted: Wed, 26 Apr 2006 @ 12:42:47 GMT
Subj: | | Extracting word from LOGONSOURCE |
|
From: | | Anomy.Anom |
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.
|