Member Avatar for readbanana

I have a column in my database that has a list of keywords. sometimes the keywords are a couple of words and sometimes just one. Each keyword (can be more than one word) is separated from a comma. for example - this is my column -
hi, how are you, good, come now, why
I want to fill each textbox with a different one of these words of phrases (hi in one box, how are you in another)

  • 3 Contributors
  • 2 Replies
  • 95 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by tesuji
Member Avatar for Kumar203

you want to split those keywords and place each keyword in individual columns. Is this the exact problem.

Member Avatar for tesuji

Hi,

In this thread I gave a solution on how to split strings into parts although it was for Oracle this statement also works on SQL Server and Sybase databases without changes.

But I am afraid, you will need a more sophisticate solution because the number of tags within a string you want to separate seems to vary.

-- tesu

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.