Search and Replace tag Value

Any trouble you encounter with the Pedias, here's the place to ask for help.
Post Reply
DanThe
Addicted to Bruji
Addicted to Bruji
Posts: 155
Joined: Tue Jan 05, 2016 6:23 pm

Search and Replace tag Value

Post by DanThe »

I would like to do a global change on one of my Tags in CDpedia (latest beta) using the command line but I can't get this to work.

I want change the Tag value of 'Peak Value 100 %' to 'Peak Value 100%'. The location of my database file is:

~/Documents/App Data/Bruji/Music/Database.cdpd

Wishlist: Search and Replace within the Pedia apps. :wink:

Thanks.
User avatar
Conor
Top Dog
Posts: 5335
Joined: Sat Jul 03, 2004 12:58 pm
Contact:

Re: Search and Replace tag Value

Post by Conor »

This one you can do within CDpedia. Search for Peak Value 100 % then menu command Edit - > Select All and Album -> Edit. The multiple edit window will come up and Peak Value 100 % should appear in the tags field. Remove it from the tags field and add Peak Value 100%, press okay and it should remove the old tag and add the new one for all the entires.

But should you need to do it in Terminal it would be:

Code: Select all

cp ~/Documents/App\ Data/Bruji/Music/Database.cdpd ~/Documents/App\ Data/Bruji/Music/Backup.cdpd
sqlite3 ~/Documents/App\ Data/Bruji/Music/Database.cdpd
UPDATE zEntry set ztag = replace(stag, 'Peak Value 100 %','Peak Value 100%');
.exit
DanThe
Addicted to Bruji
Addicted to Bruji
Posts: 155
Joined: Tue Jan 05, 2016 6:23 pm

Re: Search and Replace tag Value

Post by DanThe »

Thanks. Yes. Much easier within CDpedia. Not thinking straight... not enough coffee. :? :wink:
Post Reply