It seems that the problem would be with the last artist having a comma
in its name.
IN"[/font]Emerson, Lake & Palmer", "Earth, Wind & Fire", "Bell, Book & Candle"
OUT: "Emerson, Lake & Palmer", "Earth, Wind & Fire", "Bell & Book & Candle".</b>Usually the commas between the quotes would be represented by semicolons, especially if the artists are unquoted.<!--QuoteEnd--></div><!--QuoteEEnd-->
You do realize that the data in quotes actually represents individual groups and will probably never be part of a single artist field.
So the "out" would look much more like this:
Emerson & Lake & Palmer
Earth & Wind & Fire
Bell & Book & Candle
Oh, I just remembered one of my all-time favourites:
Dave Dee, Dozy, Beaky, Mick & Tich
would turn to, if you replace the "last" comma with an ampersand
Dave Dee, Dozy, Beaky & Mick & Tich
I intended my excursion to these groups as a word of caution that the criterion "last comma" is not always valid and that you have to filter your data first to get the best results.