12-19-2019, 06:59 AM
(12-19-2019, 03:23 AM)Zubersoft Wrote: Running SQL queries on the database is the way to go for something like this. I just tested the following and it works:
Update Songs Set Custom = trim(substr(Title,1,instr(Title, "(") - 1)) WHERE instr(Title, "(") > 0
This will strip everything after "(" in the Title. It will only impact titles that have a "(" in them. So execute the first query:
Update Songs Set Custom = Title
then execute:
Update Songs Set Custom = trim(substr(Title,1,instr(Title, "(") - 1)) WHERE instr(Title, "(") > 0
and I think you'll get exactly what you are looking for.
Mike
that worked perfectly.
I was able to access my Tablets using ANDROID FILE TRANSFER.
I've never done any SQL before so this was a first. But I got all my tablets synced.
12 tablets (Insignia, ONN, Dragon Touch). Ranging from Android 5 to 9.