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

This thread was archived. Please ask a new question if you need help.

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

  • 4 replies
  • 1 has this problem
  • 11 views
  • Last reply by 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.

Modified by Nozokyo

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 Question owner
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.