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

Improved Split function Expand / Collapse
Author
Message
Posted Saturday, September 22, 2007 1:07 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, November 12, 2013 9:25 AM
Points: 977, Visits: 250
Comments posted to this topic are about the item Improved Split function
Post #401457
Posted Monday, August 25, 2008 4:41 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, April 9, 2014 1:53 PM
Points: 320, Visits: 413
Hi Elmer! I have a question for you. I love this fn, but I have a need to split out a semicolon delimited string...then split it out again using the comma delimiter. Here is what I would like the output to look like so that I can use it:

first round
id string1
1



Thank you!!,

Angelindiego

Post #558530
Posted Monday, August 25, 2008 4:45 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, April 9, 2014 1:53 PM
Points: 320, Visits: 413
sorry Elmer, I hit a button and it "SENT" and I wasn't done!! Let me continue....

results:

original input string = 'abc,123;nko9jh'

ID String
1 abc,123
2 nko,9jh

then second result set = :

id string1 string2
1 abc 123
2 nko 9jh

is this even possible? I am messing around with the fn, trying to make this work!!




Thank you!!,

Angelindiego

Post #558531
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse