Reformating the Title field

Support
1

My album currently has the following format for the Title:

(USA) Clementine

which is:

(country) title

If possible, I would like to move the country to after the actual title:

Clementine (USA)

The actual country varies so it is not possible to split after the first n characters. However, the format of country part is consistent so the ')' character could be used as a delimiter.

It would also be necessary to not have a leading space after the reformat.

Is there a previous post that covers this type of reformating that I could be referred to?

2

Are you sure that you never have one or more additional bracket-pairs in your TITLE?

3

Looking for a similar solution would take me longer than to write:

Try Convert>Tag-Tag for ALBUM
Format string: $regexp(%album%,'(.*\))\s*(.*)',$2 $1)

Or should it be the TITLE?

4

Thanks ohrenkino. I actually needed to reformat Title rather than Album but it was easy for me to change the format string that you provided.

5

Yes, I first checked that every row had the same format.