Ed Wagner (12/19/2013)
+1 +1 +1 This function performs better than any other string splitting function I've seen and performance is very linear as you run it with larger data sets. It requires a bit of stretching at first, but once you "get it" it'll change the way you look at data. To test it out for yourself, run both solutions up to 1,000,000 rows and compare performance.
Doesn't matter how nice your are, Ed, it's still your turn to buy lunch. 😛
--Jeff Moden
Change is inevitable... Change for the better is not.