Quote:
Originally Posted by Comfy.n
Quote:
Originally Posted by Karellen
|
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