More > JRiver Media Center 27 for Windows

Change a View to sort on Composer Surname

<< < (3/4) > >>

EnglishTiger:

--- Quote from: dtc on November 24, 2020, 06:44:05 am ---Now, what do we do with the Prince symbol?

--- End quote ---
The obvious answer is replace it with "The artist formerly known as Prince"  ;D

dtc:
For reference, here are some of the original MrC regex expressions.

https://yabb.jriver.com/interact/index.php/topic,69678.msg469677.html#msg469677

https://yabb.jriver.com/interact/index.php/topic,78210.msg532803.html#msg532803

and the introduction of the SWAP and UNSWAP functions

https://yabb.jriver.com/interact/index.php/topic,94134.msg649219.html#msg649219

leezer3:
This is a slight aside, but it's got me wondering about a minor old irritation:
I've got a *lot* of Japanese / Korean content.
Unfortunately, one of the real issues with metatadata on this is anglicisation of names; Most Asian cultures work on a Surname => Forename basis.
Whilst this isn't a problem for self-tagged stuff, anything with 'official' english tags is a 50 / 50 shot as to whether it's anglicised the names to Forename => Surname or not. (Not to mention 1001 variants on auto-translate)

Essentially, I'm wondering if there's a way to detect & merge duplicated but reversed entries in this manner.

glynor:

--- Quote from: leezer3 on November 24, 2020, 01:44:04 pm ---Essentially, I'm wondering if there's a way to detect & merge duplicated but reversed entries in this manner.

--- End quote ---

How would it do that?  :o

zybex:

--- Quote ---How would it do that?
--- End quote ---

Well... you could create a sort column that sorts similar/reversed names together. You can then use it directly to Sort a view, or to fix the files with similar/reversed values so that they contain the actual same value.

Something like this - it sorts the names+surnames alphabetically, so that "Carmen Miranda" sorts the same as "Miranda Carmen":

--- Code: ---listsort(listclean(replace([composer],/ ,;),3))
--- End code ---

You can improve it to cleanup "dirtier" names so that it handles names with commas, parenthesis, articles, etc:

--- Code: ---listsort(listclean(replace(RemoveCharacters(clean([composer],2),/(/)/,.-),/ ,;),3))
--- End code ---

These split the names into words and then sorts the words alphabetically - "Wolfgang Amadeus Mozart" becomes "Amadeus;Mozart;Wolfgang". This is perhaps more useful to group related files together to then fix their tagging, since the actual order we get is not exactly by name or surname.

Navigation

[0] Message Index

[#] Next page

[*] Previous page