Home Forums SQL Server 7,2000 T-SQL How can I parse comma delimited string into columns RE: How can I parse comma delimited string into columns

  • Hi!

    Thank you for trying!  But This isn't truly a comma delimited file (like a CSV).  The number of commas varies for each row and there's that slash mark in there that indicates the logical end of the record (not the physical end), so using DTS or Bulk Insert isn't an option.  I thought about that, though! 

    So, I'm still looking for suggestionsif anyone has any!

    Thanks,

    Karen