[JohnJCAT]

How would I filter for just Titles containing the String "Trombone 2"?

[Zubersoft]

You can change the search dropdown to "Name", then enter Trombone 2 in the search field and it should search only for songs whose title contains Trombone 2.

Mike

[JohnJCAT]

You can change the search dropdown to "Name", then enter Trombone 2 in the search field and it should search only for songs whose title contains Trombone 2.

Mike

Yes, but it also finds any title that contains the word "trombone" and the number 2, not just title that contain the string "trombone 2", so a lot more rows qualify than I am interested in.

[itsme]

I guess it's the voice / instrument the score is for. I'd recommend to set a database field e.g. "source type" or "custom group" instead of or additionally to putting that into the title. Doing that allows much more flexibility for filtering.

[JohnJCAT]

I have used that method in several of my libraries, but in my primary mobilesheets library that I use for my playing (Trombone) I have 3 different trombone parts for each chart and as a result I have over 4,000 songs in that library that are named this way ("Trombone 1", Trombone 2" and "Trombone 3").  These contain lots of meta data (composer, arranger, genre, keys, tempos and stars) and are associated with many set lists so I don' want to just re-import them all.  I will just have to gradually work my way through the library and associate the charts in collections by part number.  (Unfortunately if I had known this when I started with Mobilesheets I would have used instrument names without any spaces in them.)

I run a 17-piece big band that uses all online charts (more than half of the musicians use Mobilesheets and the rest use For Score (unfortunately - it would be easier if they all used mobilesheets.)  For these people, I have well over 11,000 files that contain all the parts in our library. I often use the mobilesheets batch import to prepare what I call "loaner tablets" for the subs who do not have a tablet.  I can easily change the instrument names on all of these charts to not include spaces in the Instrument names so they will be able to filter their charts using just the name of their instrument.  It would be a lot more work for me to add all of these charts to distinct "groups" in the loaner tablets.

Thanks again for your wonderful product and for your excellent support.

[Geoff Bacon]

Sciurius has developed some MSPro tools that can manipulate the mobilesheets database (I've never needed them).

I'm sure that you would be able to extract the metadata, global edit it e.g. "Trombone 2" to "Trombone2" and then reimport it.

Make sure you make a backup before you start

Geoff

[JohnJCAT]

Yeah I had thought of just updating the SQLite Database using something like below (I have all the "Trombone 2" at the end of the song titles.)

select id, title,
concat(substr(title,1, length(Title)-10),"Trombone_2") as Song
from Songs
where title like "%Trombone 2"

changed into an update.

Then restore over the DB in my Windows 11 version???

[Zubersoft]

That seems like it should work so long as you've been consistent with the way you've named things (where "Trombone 2" only shows up at the end of the song title). You can just copy the .db file over the existing one under C:\Users\<your username>\AppData\Local\Packages\41730Zubersoft.MobileSheets_ys1c8ct2g6ypr\LocalState if you are using the Microsoft Store version.

Mike