Search and Replace tag Value

[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.

Thanks.

[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]

Thanks. Yes. Much easier within CDpedia. Not thinking straight... not enough coffee.