Reverse (Artist) name within a field... remove white space

2 Part Request:

  1. Is it possible to reverse an artist name within a field?

Present configuration for Artist & Album Artist is: The, $1

Emotions, The
Eagles, The

etc...

However, what I would like to do is reverse that under Performers (Mixed Artist) field.

So this: Format Value "Artist Names": Primary Artist: %artist%

Primary Artist: Emotions, The

Becomes:

Primary Artist: The Emotions

Is that possible?

  1. How to align metadata up top and to the left.?

I sometimes copy and past artist infomation that has bullets and therfore doesn'r align to the left or when deleting a line, doesn't align up top... can i bulid an action to do this?

Example shown (although the bullets do not show when cutting and pasting it doesn't not align to the left. Need and action to replace white space to align all to the left and up top where it's just blank space.)

Cannonball Adderley — alto saxophone
Miles Davis — trumpet
Hank Jones — piano
Sam Jones — bass
Art Blakey — drums

Should look like

Cannonball Adderley — alto saxophone
Miles Davis — trumpet
Hank Jones — piano
Sam Jones — bass
Art Blakey — drums

Cleaning up my old files and want to get them all corrected at once.

Thanks

This will not work as you do not cater for all the exceptions, esp. in names.
There is a group called "The The" - do you really want to change that to "The, the"?
What about "Grandmaster Flash and the furious five"? -> Grandmaster Flash and furious five, the" or "Grandmaster Flash and furious, the five"?
"Adam and the Ants"?
"At the Gates"?
"B.G The Prince of Rap"?
"The Jesus and Mary Chain"?
"The Living Tombstone"?
"The Style Council"?
My advice: leave the names as they are. If you need a different sorting order, fill the field ARTISTSORT or the like with just the stripped name.

The basic procedure: create an action of the type "Replace with regular expression"
Search string:
^The (.*)
Replace string:
$1, The

If you have a leading string, repeat that:
Search string:
Primary Artist: The (.*)
Replace String:
Primary Artist: $1, The

If you want to get rid of leading or trailing blanks, format the value with the $trim() function.