I have a numerous tracks where the featured artists are listed in many different ways --
ex 2-
Cheat On You Feat. Jay-Z, Mase & Lil Cease
Artist : 112
ex 3-
Cheat On You Ft. Jay-Z, Mase & Lil Cease
Artist : 112
ex 4-
Cheat On You F/ Jay-Z, Mase & Lil Cease
Artist : 112
ex 5-
Cheat On You (Feat. Jay-Z, Mase & Lil Cease)
Artist : 112
I've searched the forums and found two different codes --
one to change all the featured artists listings to the same uniform listing --
Reg ex--
title -
" \(ft\. | ft\. | ft | f\. | \(featuring | (featuring) | featuring | \(feat\. |(featuring) | \(feat | feat\. "
replace with
(feat.)
The other to change (feat.) to the artist field.
Guess value - %artist% --- $replace(%title%,'(','{(',')',')}')
artist - %artist%[ %temp%]
remove fields TEMP
while i know this is an around about way to accomplish this, it was the only thing that I could follow. Unfortanetly this is now what I come up with --
Cheat On You"
112 (feat.)} "Jay-Z, Mase & Lil Cease)
How can I clean this up and get rid of the extra " in the title field and the } " ) in the artist field?