Skip to main content ↑ ↓

Notice

Please note that most of the software linked on this forum is likely to be safe to use. If you are unsure, feel free to ask in the relevant topics, or send a private message to an administrator or moderator. To help curb the problems of false positives, or in the event that you do find actual malware, you can contribute through the article linked here.
Topic: Search for artist with similar name but different case (Read 1428 times) previous topic - next topic
0 Members and 1 Guest are viewing this topic.

Search for artist with similar name but different case

As stated, I am currently trying to correct any artists name that are having differences in casing. I was just wondering what query should I use?

Eg. the search query will return Namie Amuro and Namie amuro.

Search for artist with similar name but different case

Reply #1 –
Create a Facets UI element with two panes:

(1) $lower(%artist%) column, subitems statistic
(2) %artist% column

Click twice on the subitems column header to sort by subitems in descending order.
Entries with more than one subitem need to be corrected.
Select each entry to see the different spellings in the second pane.