Filtering by Genre with metadata fields with/without space

Server Version#: 1.27.1.5916
Player Version#: 4.76.1
Using the Music Library type. When I save a new CD in a Library, I set the Genre metadata using a semicolon to separate the fields. If I tag two CD’s using the next example:

  • “USA;Jazz” (first CD)
  • “USA; Jazz” (second CD)
    I get two separated fields in the Genre field: “Jazz” (without space) and " Jazz" (with space).
    Expected (wished) is that both cases will result in only one “Jazz” Genre field.
    Questions about that:
  • Could it be implemented in the server code that a “trim” is done for the items in the Genre, zo that both “Jazz” and " Jazz" are saved in the database as “Jazz”?
  • I do have more than 5.000 CDs in my collection. Is it possible to have a query for the database to trim all the spaces at the begin and end of the Genre fields? (It is now almost impossible to manually trim the complete collection).
    Many thanks in advance for your help.
    Gustavo

Thanks for the speedy answer. Do you have an approximate indication about when the fix will be available? In the main time, could it be possible to fix it directly in the database or using an API as a workaround? I have more than 5,000 CDs in my collection, and it is really impossible to trim everything manually.

I’m hoping too that it’s fixed quickly, but most tag editors and music library managers can do a find-and-replace for "; " to “;” so you don’t have to do it one by one.