Words Count

[DetlevD]

@MotleyG

Apologies if my original post was vague. In the artist field I wanted to flip FIRSTNAME LASTNAME to LASTNAME, FIRST NAME and also FIRSTNAME MIDDLENAME LASTNAME to LASTNAME, FIRSTNAME MIDDLENAME. ...

Read there ...
Regular Expressions
Regular Expressions
Multiple value artist tag to multiple value artistsort
Need help with regex for ARTISTSORT
Automating Changes to Artist Values

@MotleyG

... The word count function request was to filter the artist field to 2 or 3 word strings in order to try to simply this process, and to run it in larger batches.

Filter for counting "words", which are separated by one or more space characters:

"$if(%ARTIST%,$add($len($regexp($regexp(%ARTIST%,' +',' '),'[^ ]',)),1),0)" GREATER 1

... will display all artists with more than one word.

"$if(%ARTIST%,$add($len($regexp($regexp(%ARTIST%,' +',' '),'[^ ]',)),1),0)" IS 3

... will display all artists with three words.

DD.20140821.0756.CEST