That did it! Thanks a ton!
May as well throw another out then. My publisher field doesn't appear to be a multi-value tag-field like my genre field was in the original post. My publisher field has multiple publisher's as well, yet in a single value, and I'd like to cut that down to the first one listed. Since we're not dealing with multi-value tag-fields, I need a different approach.
So, example layout of my publisher field:
Columbia; Columbia Records; A Third; A Fourth
So, each entry is separated by a semicolon.
I'd like the results to look like:
So once again, I'd like to cut all text to the right of the semicolon, along with that semicolon.
I have a two step action, one to remove all text to the right of the semicolon, and another after that to actually just replace the semicolon with nothing:
Action type: Replace with regular expressions
Regular expression: ^(.+;\s)(.+)
Replace matches with:$1
Then just a simple replace with blank to remove the lasting semicolon.
I'm sure there's an easier way to do this. If not, let me know!