Splitting the string with unique delimiter.

• prashan

  SSC Journeyman

  Points: 78

  More actions

  June 25, 2009 at 9:34 pm

  #211273

  Comments posted to this topic are about the item Splitting the string with unique delimiter.

• nigel.

  SSChampion

  Points: 11636

  More actions

  June 29, 2009 at 2:36 am

  #1016654

  This can (and should) be done without having to resort to a WHILE loop.

  See Jeff Moden's article here[/url] to see how and why.

  Nigel
  How to post questions

• kiranjadav1309

  Grasshopper

  Points: 15

  More actions

  February 19, 2010 at 1:04 am

  #1121598

  nice stuff. thank you.

• lora.pennington

  SSC Veteran

  Points: 236

  More actions

  March 12, 2010 at 10:21 am

  #1132854

  Is there a way to do this horizontally instead of vertically ?

  165476~2345678~123456

  Column1 column2 column3

  165476 2345678 123456

  I have a field in an SQL table that I need to parse out horizontally into multiple columns depending on the number

  of deliminated characters in the string.