This site will have limited functionality while we undergo maintenance to improve your experience. If an article doesn't solve your issue and you want to ask a question, we have our support community waiting to help you at @FirefoxSupport on Twitter and/r/firefox on Reddit.

Avatar for Username

Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

Wo archive tread sia. Meɖekuku bia biabia yeye ne ehia kpeɖeŋu.

Bookmarks, bulk edit, searc/replace, places.sqlite/html ?

  • 4 ŋuɖoɖowo
  • 1 masɔmasɔ sia le esi
  • 11 views
  • Nuɖoɖo mlɔetɔ cor-el

Nozokyo
Nozokyo
more options

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.

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.

Nozokyo trɔe

All Replies (4)

FredMcD
FredMcD
more options

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.

Nozokyo
Nozokyo Biabia la
more options

EDIT: I modified this question title & contect since original post.

cor-el
cor-el
  • Moderator
  • Top 10 Contributor
more options

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.

cor-el
cor-el
  • Moderator
  • Top 10 Contributor
more options

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.