Improved Split function

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 Elmer Miller » Improved Split function

Improved Split function

Rate Topic

Display Mode

Topic Options

Author

Message

Elmer Miller

Posted Saturday, September 22, 2007 1:07 PM

SSC Eights!

Group: General Forum Members
Last Login: Friday, May 03, 2013 1:52 PM
Points: 977, Visits: 232

Comments posted to this topic are about the item Improved Split function

Post #401457

Angelindiego

Posted Monday, August 25, 2008 4:41 PM

Old Hand

Group: General Forum Members
Last Login: Friday, April 12, 2013 11:22 AM
Points: 312, Visits: 386

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

Angelindiego

Posted Monday, August 25, 2008 4:45 PM

Old Hand

Group: General Forum Members
Last Login: Friday, April 12, 2013 11:22 AM
Points: 312, Visits: 386

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 »

Permissions