Splitting the string with unique delimiter.

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

nigel. SSChampion Points: 11636 More actions · Answer 1

This can (and should) be done without having to resort to a WHILE loop.

See Jeff Moden's article here[/url] to see how and why.

kiranjadav1309 Grasshopper Points: 15 More actions · Answer 2

Grasshopper

Points: 15

February 19, 2010 at 1:04 am

nice stuff. thank you.

lora.pennington SSC Veteran Points: 206 More actions · Answer 3

Is there a way to do this horizontally instead of vertically ?

165476~2345678~123456

Column1 column2 column3

165476 2345678 123456

I have a field in an SQL table that I need to parse out horizontally into multiple columns depending on the number

of deliminated characters in the string.