Automating Changes to Artist Values

[DetlevD]

@bluewammer

Many Thanks, DetlevD. Unfortunately at present the Action leaves me with a leading space at the beginning of the new name, which of course means that my control point now puts it at the beginning of the alphabetical sort. I have experimented but can't work out how to amend the format to ensure that there is no leading space in the new name.

Have a look at the trim functions $trim, $trimLeft, $trimRight to remove surrounding spaces.

Try this ... for only one artist name

$regexp(%ARTIST%,'([^;]+)\s([^;]+)','$2, $1')

Try this ... for multiple artist names

$trimLeft($regexp(%ARTIST%,'([^;]+)(\s[^;]+)','$2, $1'))

... or ...

$trimLeft($regexp(%ARTIST%,'([^;]+)\s([^;]+)',' $2, $1'))

DD.20120630.1120.CEST