Splitting the string with unique delimiter.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Prashanth Jayaram » Splitting the string with unique delimiter.

Splitting the string with unique delimiter.

Rate Topic

Display Mode

Topic Options

Author

Message

prashan

Posted Thursday, June 25, 2009 9:34 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, May 17, 2013 9:01 AM
Points: 8, Visits: 222

Comments posted to this topic are about the item Splitting the string with unique delimiter.

Post #742348

nigel.

Posted Monday, June 29, 2009 2:36 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:57 AM
Points: 1,163, Visits: 2,600

This can (and should) be done without having to resort to a WHILE loop.
See Jeff Moden's article here to see how and why.

--
Nigel

Useful Links:
How to post data/code on a forum to get the best help
The "Numbers" or "Tally" Table - Jeff Moden

Post #743418

kiranjadav1309

Posted Friday, February 19, 2010 1:04 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, May 28, 2010 8:44 AM
Points: 1, Visits: 21

nice stuff. thank you.

Post #868804

lora.pennington

Posted Friday, March 12, 2010 10:21 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 9:33 AM
Points: 1, Visits: 5

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.

Post #881959

« Prev Topic | Next Topic »

Permissions