I have a big list of albums that are properly tagged (filename, album, artist etc).
My new car media player (Volvo XC40) cannot handle albums that are collections from various artists.
The albums that come from one artist show ok on the music library. The albums that are collections with songs from many artists are separated. Each song as a separate album. It seems as if the media player sorts the database by both artist and album. The library is a mess.
The only way to solve this is in "collection albums" is to have in the "artist" field one value like "Various artists".
So I merged the artist and title in one field (Title) with this value "%artist% | %title%" to keep the information and be able to view the actual artist in the screen.
Then I replaced the artist names to "Various artists".
But, doing that it also replaced the actual value of the artist and now it shows "Various artists | Hotel california".
Any ideas on how to import values to mp3tag from excel file, so that I can replace the values by a file not an online db.
Thank you in advance for your help.