View Single Post
Old 03-08-2024, 01:59 AM   #14
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,820
Karma: 30277270
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by Comfy.n View Post
Quote:
Originally Posted by Karellen View Post
It should be pretty easy to edit notes.db using DB Browser...

https://sqlitebrowser.org/
hmm, I have that program. But I don't see something like a Search and replace function in it? (i mean, without having to know how to issue sql commands...)
You could do this:
  • export the notes table in notes.db to a CSV
  • edit the CSV with a text editor or spreadsheet program
  • import the edited CSV back into the notes db notes table

Do an export and import without any edits first to make sure you have the basics working. The export and import options are in the File menu of DB Browser for SQLite.

I've done that with tables from metadata.db to good effect… a long time ago.

And of course work on a copy of .calnotes.

Added: just noticed the notes table in notes.db is virtualised for FTS, not sure of the implications of that.

BR

Last edited by BetterRed; 03-08-2024 at 02:04 AM.
BetterRed is offline   Reply With Quote