Search and Replace tag Value

Any trouble you encounter with the Pedias, here's the place to ask for help.

Search and Replace tag Value

Postby DanThe » Sat Dec 16, 2017 11:23 am

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.
DanThe
Addicted to Bruji
Addicted to Bruji
 
Posts: 69
Joined: Tue Jan 05, 2016 6:23 pm

Re: Search and Replace tag Value

Postby Conor » Sat Dec 16, 2017 2:12 pm

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
User avatar
Conor
Top Dog
 
Posts: 4913
Joined: Sat Jul 03, 2004 12:58 pm

Re: Search and Replace tag Value

Postby DanThe » Sun Dec 17, 2017 10:42 am

Thanks. Yes. Much easier within CDpedia. Not thinking straight... not enough coffee. :? :wink:
DanThe
Addicted to Bruji
Addicted to Bruji
 
Posts: 69
Joined: Tue Jan 05, 2016 6:23 pm


Return to Support