Bookmarks, bulk edit, searc/replace, places.sqlite/html ?
Greetings.
My situation is I have multiple bookmarks (100++) with a Title/Name text format eg. "ABCD...123...EFG...HIJK ...".
I need to trim off the first characters and ideally the last characters of the Title, leaving eg. "123...EFG...". A search-and-replace operation would be best if possible.
I can move all the bookmarks that need to be modified, to a separate bookmarks folder if necessary.
Can anyone please suggest a way to do this, using a add-on tool or utility to safely modify the SQLite 'places.sqlite' database or bookmarks.html
I knew some basic SQL script years ago and think I can pick up some again or SQlite.
Or - export / backup bookmarks to to a 'json' or bookmarks.html file, edit the file using search-replace in a text editor, then restore from the file
- Are the backup json and export html files in plain ASCII characters that I can edit the Title text fields
Thanks,
Michael.
Modified by Nozokyo
All Replies (4)
I have not heard of such a thing.
Go to the Mozilla Add-ons Web Page {web link} (There’s a lot of good stuff here) and search for what you want.
EDIT: I modified this question title & contect since original post.
You should be able to make the modifications to a JSON backup and restore this file.
You can open the file in the Scratchpad (Firefox/Tools > Web Developer) and click the "Pretty Print" button to format the file for readability. You can use a suitable text editor that can support regular expressions if it can't be done with a normal search and replace.
Note that an HTML file can be opened in a Firefox tab and that you can easily use JavaScript to do the search and replace of specific elements.
- https://developer.mozilla.org/DOM/Document.querySelectorAll
- https://developer.mozilla.org/Web/JavaScript/Reference/Global_Objects/RegExp
- https://developer.mozilla.org/Web/JavaScript/Reference/Global_Objects/String/replace