The Problem is as follows
The Artist name is given as
Peter Gabriel or Fela Kuti & the Africa 70
I want it to be changed into
Gabriel, Peter or Kuti, Fela & the Arica 70
How can I do this ?
Thanks for any help
Piton
You can use a group of actions like following.
Begin Actionsgroup TEST
Action #1
Actiontype 5: Format tag field
Field: ARTIST_1
Formatstring: $regexp(%artist%,^(.+?)\s+or\s+(.+?)\s+&\s+(.+?)$,$1)
Action #2
Actiontype 5: Format tag field
Field: ARTIST_2
Formatstring: $regexp(%artist%,^(.+?)\s+or\s+(.+?)\s+&\s+(.+?)$,$2)
Action #3
Actiontype 5: Format tag field
Field: ARTIST_3
Formatstring: $regexp(%artist%,^(.+?)\s+or\s+(.+?)\s+&\s+(.+?)$,$3)
Action #4
Actiontype 5: Format tag field
Field: ARTIST_1
Formatstring: $regexp(%artist_1%,^(.+?)\s+(.+?)$,$2',÷'$1)
Action #5
Actiontype 5: Format tag field
Field: ARTIST_2
Formatstring: $regexp(%artist_2%,^(.+?)\s+(.+?)$,$2',÷'$1)
Action #6
Actiontype 5: Format tag field
Field: ARTIST
Formatstring: %artist_1%÷or÷%artist_2%÷&÷%artist_3%
Action #7
Actiontype 9: Remove fields
Fields to remove (semicolon separated): artist_1;artist_2;artist_3
Note: Replace one special character ÷ with one space character.
End Actionsgroup TEST (7 Actions)
From: Peter Gabriel or Fela Kuti & the Africa 70
To: Gabriel, Peter or Kuti, Fela & the Africa 70
DD.20081124.1938.CET