Delimited String in one Column

Question

Delimited String in one Column

AndrewSQLDBA

SSC-Insane

Points: 21827
More actions
October 20, 2010 at 2:37 pm

#388058

Hello Everyone
I am working with a delimited string in a single column. Yes, I know. I am ready to kill someone over this.
But anyway, how can I write some code to parse that string. Below is an example:
Ivory,White,Sage,Brown,Black,Lavender,Caribbean,Lt Pink,Dark Purple
Some rows have more and some have less, there is not a set length.
I am load on this one
Thank you in advance
Andrew SQLDBA

Viewing 7 posts - 1 through 6 (of 6 total)

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

LutzM SSC Guru Points: 107049 More actions · Answer 1

Did you search this site for "DelimitedString8K" on this site?

This is a function posted by Jeff Moden. If you get the "right thread" (don't recall the link right now) you'll end up with several very fast versions, including a CLR (Paul White's preference, as it seems 😉 )

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

AndrewSQLDBA SSC-Insane Points: 21827 More actions · Answer 2

Very nice, that is perfect.

Really fast and works perfectly

Andrew SQLDBA

LutzM SSC Guru Points: 107049 More actions · Answer 3

Which one did you try? T-SQL or CLR?

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

AndrewSQLDBA SSC-Insane Points: 21827 More actions · Answer 4

AndrewSQLDBA

SSC-Insane

Points: 21827

October 20, 2010 at 4:33 pm

#1239996

The CLR

It is rather quick.

Andrew

ralm Hall of Fame Points: 3156 More actions · Answer 5

Hi Andrew,

Can you share the link where you found the options.

^{[font="Verdana"]Regards,
Rals[/font].}

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 6

rajesh.subramanian (10/21/2010)
Hi Andrew,
Can you share the link where you found the options.

here is one : http://www.sqlservercentral.com/Forums/Topic943562-338-1.aspx#bm944589

Am hunting down Paul White CLR.. will update soon...