InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 16:54:32 GMT20http://www.teradata.com/teradataforum/Topic11750-9-1.aspxHello,Doing that in SQL may be difficult. Doing that in UDF will be simple and easy, if you have experience in UDFs.You can have a similar sort of UDF as suggested at: http://www.teradata.com/teradataforum/Topic11751-9-1.aspxHTH.Regards,AdeelSun, 08 Jun 2008 23:26:48 GMTAdeel.Chaudhryhttp://www.teradata.com/teradataforum/Topic11750-9-1.aspxHi allPlease help...,These are some logonsource string examples out of which I need to extract only the 4th last word (For example here YZIF7295, FWPG8206, ADM-MM4 or ADMMDORD).(Maybe with the INDEX or POSITION functions...with the SUBSTRING function)(I want to obtain the string after the third space from the end.)(TCP/IP) 0AAE IPA AAA.BBB.CCC.NET 3956 YZIF7295 QUERYMAN 01 LSS (TCP/IP) 094D IPW AAA.BBB.CCC.NET 3024 FWPG8206 MMC 01 LSS (TCP/IP) 0E9D IPY AAA.BBB.CCC.NET 7076 ADM-MM4 DTSRUN 01 LSS (TCP/IP) 89A7 IPZ AA.BB.CCC.NET 622800 ADMMDORD DB-UNLOAD.IMPL 01 LSS Thanks in advance...DidierSun, 08 Jun 2008 05:58:51 GMTDidier Monsergent