Actually, the method I described is probably the simplest. Just follow these steps exactly:
1. Copy the code in Fig. 21 of that article.
2. Open a SSMS query window, set the database to your database from the dropdown, paste the copied code to that window and click execute. Now close that window.
3. Open another SSMS query window and type the query:
declare @str varchar(256) = 'string= /usr/open/windows/whatever/blah/blah.sh';
SELECT * FROM dbo.DelimitedSplit8K(@str,'/');
4. Take a look at the output - it will have the data you need, nicely split.
Give it a try, and you will love it 
parse a string
Posted - 11/29/2012 : 14:59:05
