feature request: search and replace in multiple notes in source code

Whateverr · October 19, 2019

It would be a great feature to be able to search and replace in multiple notes in source code.

Let say I have 100+ local links in dozens of notes to modify. This currently can't be done (except by "playing" with the sqlite which is not convenient).

dragonfly · October 19, 2019

I have used ripgrep for find and replace operations and I see that there is an adapter to grep sqlitedb.

https://github.com/phiresky/ripgrep-all

https://docs.rs/ripgrep_all/0.8.7/ripgrep_all/adapters/sqlite/index.html

But I would clone your existing sqlitedb and experiment on the clone. Hacking sqlitedb is not recommended by the experts in this forum. My knowledge of internal scripting via API is thin.

Other than this untested idea I would explore automation scripting.

Whateverr · October 20, 2019

Thanks dragonfly for this.

For simple find and replace,I use DB browser for sqlite* with sql (). For more complex search/replace (ex: case insensitive with multiple occurrence in several notes), I use Python sqlite3.

So I was able to get everything done but I thought it would be great to have this feature so that one doesn't have to rely on programming knowledge to do that.

*https://sqlitebrowser.org/