SQLServerCentral / Discuss content posted by Andy Brown / Article Discussions / Article Discussions by Author / Function to Split a Delimited String into a Table / Latest Posts

RE: Function to Split a Delimited String into a Table

g.chakhidze — Wed, 09 Mar 2011 02:04:27 GMT

Hi,Thank you, I've found this function very useful.There is a little typo at the line SET @list = LTRIM(RTRIM(@list)) + ','Instead of concatenating with default value (,), you must concatenate with passed in @delimiter argument. SET @list = LTRIM(RTRIM(@list)) + @delimiterWithout this, if you use delimiter different than comma, it will not add last row to the resulting table.For example:select * from DStringToTable(N'one|two', N'|')returns tablevalue-----onewhich is missing value 'two'

RE: Function to Split a Delimited String into a Table

Stylez — Wed, 13 Feb 2008 23:59:11 GMT

Hi good Sirthanks for doing the string split function. i would like to kindly ask if you have a sample code for my scenario below;Column 1 = IDColumn 2 = LastnameColumn 3 = Job Descriptionand then i will declare a variable to be used in inserting the columns mentioned abovedeclare @Value varchar(4000)set @value = 'IDValue,Lastnamevalue,JobDescriptionvalue'i noticed that you are inserting these values in a single column. is it possible to save these values in a seperate column named ID,Lastname and Job Description? your assistance is very much appreciated.Best RegardsN.O.E.L.

RE: Function to Split a Delimited String into a Table

philcart — Mon, 24 Sep 2007 06:10:00 GMT

SQL 2005 variant that doesn't use a loop.

http://philcart.blogspot.com/2007/06/split-function.html

Could be easily modified to work with nvarchar(4000)

Function to Split a Delimited String into a Table

Andy B. — Mon, 24 Sep 2007 05:10:36 GMT

Comments posted to this topic are about the item [B]Function to Split a Delimited String into a Table[/B]