This one is a little bit trickier as it consists of multiple pairs that need to be rearranged.
Action type: Replace with regular expression
Field: ALBUMARTIST or ALBUMARTISTS (depending on the actual field name)
Regular expression: (.+?) [-|ā|ā] (.+?)(,|$)(\s?)
Replace matches with: $2 - $1$3$4
Florian! That was quick. Thanks.
Tried this, followed your instructions and copied your formulas, couldn't get it to work, nothing happened in the field, which is named ALBUMARTIST of course. The one I tried looked like this:
Bass Clarinet; Acoustic Guitar; Electric Guitar ā Doug Mathews, Drums; Tenor Saxophone; Piano ā Anthony Cole, Tenor Saxophone; Soprano Saxophone; Flute; Vocals; Piano ā Sam Rivers
It's hard to track by eye, but there are different types of dashes and your example string uses ndashes.
- dash
ā ndash and
ā mdash
I've updated the regular expression above to take into account the different types of dashes. The resulting string will use normal dashes (or whatever you'll put there).
Thank you! Works perfect!
The dashes comes from different places (Discogs etc), I understand now that they are different, hard to see.
I also understand why I couldn't sort this out myself...Hahahaha.
Great help, thank you, Florian! /Henry