Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Splitting the string with unique delimiter. Expand / Collapse
Author
Message
Posted Thursday, June 25, 2009 9:34 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 10:30 AM
Points: 20, Visits: 532
Comments posted to this topic are about the item Splitting the string with unique delimiter.
Post #742348
Posted Monday, June 29, 2009 2:36 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 4:43 AM
Points: 1,184, Visits: 2,680
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
Posted Friday, February 19, 2010 1:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 28, 2010 8:44 AM
Points: 1, Visits: 21
nice stuff. thank you.
Post #868804
Posted Friday, March 12, 2010 10:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 3, 2014 9:57 AM
Points: 4, Visits: 13
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 »

Add to briefcase

Permissions Expand / Collapse