I lke to move the THE from the end of artist and have look at exsamples but i can't figure out what i'm doing incorrect. i tried
action
format value
field Artist
string the %arist%
result i'm getting is the Temptatons the
how can i remove the the from the end please?
What I try to point out:
If you define a regular expression with a pattern that contains a comma but the data that you treat with it does not have a comma, it will not work.
Also, you have mixed up the regular expression with the Replace string. The field contents in the dialogue should be swapped.