Split String question

• SQL_Surfer

  SSCrazy Eights

  Points: 8320

  More actions

  February 16, 2012 at 10:41 am

  #150831

  I have a table with two fields.

  IDValue

  12345kais#2323232#def#323#

  THe requirement is to show like below.

  12345kais

  12345 2323232

  12345 def

  12345 323

  What would be the best way to accomplish this?

• venoym

  SSCarpal Tunnel

  Points: 4161

  More actions

  February 16, 2012 at 11:37 am

  #1448061

  Use the Split function outlined in this article:

  http://www.sqlservercentral.com/articles/72993/

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  February 16, 2012 at 12:59 pm

  #1448106

  To give you an example of how to use the splitter in that article with your sample data:

  create table #MyTable

  (

  ID int,

  SomeValue varchar(50)

  )

  insert #MyTable

  select 12345, 'kais#2323232#def#323#'

  select ID, Item from #MyTable

  cross apply dbo.DelimitedSplit8K(left(SomeValue, datalength(SomeValue) - 1), '#')

  drop table #MyTable

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/