IPB

Welcome Guest ( Log In | Register )

> foobar2000 General Forum Rules

This is NOT a tech support forum.
Tech support questions go to foobar2000 Tech Support forum instead.

See also: Hydrogenaudio Terms of Service.

Search for artist with similar name but different case
D.Sync
post May 17 2012, 18:43
Post #1





Group: Members
Posts: 186
Joined: 22-March 07
Member No.: 41742



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.
Go to the top of the page
+Quote Post
 
Start new topic
Replies (1 - 1)
Frank Bicking
post May 17 2012, 19:04
Post #2





Group: Super Moderator
Posts: 1833
Joined: 24-July 02
From: Berlin, Germany
Member No.: 2776



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.
Go to the top of the page
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 18th December 2014 - 06:42