I have this data:
Eminem; RBX; Sticky Fingaz
Dr. Dre; Eminem; Nate Dogg; Snoop Dogg; Xzibit
what I need is to transform the character ";" in "feat." another in "comma" and another in "&" getting the following result:
Dido feat. Eminem
Eminem feat. RBX & Sticky Fingaz
Dr. Dre feat. Eminem, Nate Dogg, Snoop Dogg & Xzibit
The first character ";" always be "feat."
The last character ";" will always be "&"
And the other characters ";" which will be the middle will be "comma"
It is to do this without getting so...
Dr. Dre feat. Eminem feat. Nate Dogg feat. Snoop Dogg feat. Xzibit
I do not know where to start...
I await your help.
thank you in advance, embrace!