Get word from string based on its position

Question

Hi I dont want to use split function logic. I have strin like 'ThisisC#CornerWebsite' If i provide 2 then it must give is If i provide 4 then it must give corner If i provide 5 then it must give website and so on. How can i do this

Manish Kumar · Answer

You can do with xml. Try below query for your 24 and 5 declare @string varchar(500) set @string='ThisisC#CornerWebsite' select CAST((' '+REPLACE(@string'' ' ')+' ') AS XML).value('(/X)[2]' 'varchar(100)') select CAST((' '+REPLACE(@string'' ' ')+' ') AS XML).value('(/X)[4]' 'varchar(100)') select CAST((' '+REPLACE(@string'' ' ')+' ') AS XML).value('(/X)[5]' 'varchar(100)')

Ramesh Palanivel · Answer

Hi Swap Try this code using System; using System.Collections; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace SplitStringWithoutUsingSplitMethod { class Program { static void Main( string [] args) { string str = ThisisC#CornerWebsite ; ArrayList arrayList = new ArrayList(); string Temp =  ; for ( int i = 0; i { if (str[i] != '' ) { Temp = Temp + str[i]; continue ; } arrayList.Add(Temp); Temp =  ; } Console.WriteLine( Enter the no 1 to  + arrayList.Count); int option =Convert.ToInt32(Console.ReadLine()); if (option 0) { Console.WriteLine(option+  position is =  +arrayList[option - 1]); } else { Console.WriteLine( Enter only 1 to  + arrayList.Count); } Console.ReadLine(); } } }

swap swap · Answer

Hi manish  the script working perfectely but when im passing dynamic value instead of 24 and 5 like @Index it gives me error. The argument 1 of the XML data type method value must be a string literal.

swap swap · Answer

Sorry i forgot to mention that i need to do it in sql. I tagged my answer to sql server tag. Thanks for t reply.