[Cerio]

For exemple here:
   
 
In this case, I can batch edit all Diana Ross songs and assign "Diana Ross" as artist, which is great. But if I'd like to remove "Diana Ross" from the titles, do I need to change the title one by one, or is it there any faster way ?

(I have hundreds of examples like that on my DB)

[Zubersoft]

You'll have to change the titles one-by-one. There is no easy way to batch edit titles like that (the logic of trying to find characters that are identical between every selected title would be a little tedious, as well as trying to create a UI for editing only the sections of the title that are identical between every title).

Mike

[Cerio]

Thanks Mike

[itsme]

With Sciurius' MSPro Tools https://github.com/sciurius/MSPro-Tools you might be able to do what you want. It's a packet of Perl scripts for a number of useful tasks.
With get_meta.pl you can read all meta data out of the MobileSheets database into a .JSON file. Then you can manipulate this .JSON export with any text editor, apply search & replace actions as required and reimport it into the MobileSheets database with upd_meta.pl.
I used MSPro Tools several times successfully. Maybe it needs an update to handle the new database format, but that should not be problem as Sciurius is very active, kind and cooperative.

[Zubersoft]

It's also true that if you know how to use SQL queries, you can just open the SQLite database file in a SQLite editor like SQLiteStudio, and perform a query on the Songs table to replace "Diana Ross" with "", effectively removing it from all titles.

Mike

[Cerio]

Thanks both for the tips. In my case, I suspect this task would be faster just by renaming those files one by one, but it's good to know that these kind of tools these kind of tasks, it may come handy in the future.