I know your first reactions are going to be "Read the FAQ" the answers are there. I have looked, cut and pasted the solutions, changed the tag names etc to my purposes and tested several of the solutions and non worked for me.. Now I assume it is because I am doing something wrong when I try to create the actions or I don't understand the syntax.
I have items in the %artist% tag in the format where the group lead is followed by a " & " followed by the group name. i.e. Bob Marley & The Wailers. What I want to do is copy everything before the " & " to the %albumartist% tag but only if the artist album is blank.. Since none of the examples I found worked for me I tried this:
Regular expression: %artist% HAS " & " AND %albumartist% IS "" (this works in the filter)
Replace matches with: $LEFT(%artist%,$LEN(%artist%) - $STRCHAR(%artist%," & ")).
When I click on the Action I see this:Regular expression "ALBUMARTIST":"%artist% HAS " & " AND %albumartist% IS "" -> "$LEFT(%artist%,$LEN(%artist%) - $STRCHAR(%artist%," & "))"
This kind of logic works in many languages and there seem to be the correct scripting functions to do this but so far I have not been able to make it work.
Am I way of base with my expectations of the scripting language or is my syntax wrong???