Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    100

    Unanswered: Splitting comma delimited field

    Hello all,

    I am trying to split a comma delimited field into separate fields. The current field contains several names and I would like to split the field into each field containing one name:

    Existing:

    Team
    -------
    John Doe, Jane Doe, George Bush, John Kerry, Sam The Sham

    Goal:

    Field1_______Field2_______Field3_________Field4___ ____Field5
    John Doe____Jane Doe____George Bush____John Kerry___Sam The Sham

    TIA!

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    but you have given the answer in your question.
    declare an array and use the split() function to feed it.

    izy
    currently using SS 2008R2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •