Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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.



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016