Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Extracting word from LOGONSOURCE
From:   Anomy.Anom


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 DBC      4091  WORD1  APPL1  01 LSS
     (TCP/IP) 08A8  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  AAA.BBB.CCC.NET   2884  WORD2 APPL4  01 LSS
     (TCP/IP) 0F55 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>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020