How tp Change Firstname and Surname

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