解析Mozilla FireFox JSON文件的快速而肮脏的方法 [英] Quick and dirty way to parse a mozilla firefox json file

问题描述

我想从firefox创建并输出.txt文件的.json书签备份中删除所有url.

以下是文件中一个对象的示例:

{"index":1,"title":"Bookmarks Toolbar","id":3,"parent":1,"dateAdded":1219177758531250,"lastModified":1288873459187000,"annos":[{"name":"bookmarkProperties/description","flags":0,"expires":4,"mimeType":null,"type":3,"value":"Add bookmarks to this folder to see them displayed on the Bookmarks Toolbar"}],"type":"text/x-moz-place-container","root":"toolbarFolder","children":[{"title":"","id":25,"parent":3,"dateAdded":1224693644437500,"lastModified":1236888979406250,"annos":[{"name":"placesInternal/GUID","flags":0,"expires":4,"mimeType":null,"type":3,"value":"{f6066e21-10ff-46a2-af7a-2891f8dca345}0"}],"type":"text/x-moz-place","uri":"http://www.google.com/"}

这些对象用逗号分隔，并且应该全部包含至少一个成员，该成员包含一个字符串，其值是书签的url.

以下是.txt文件中包含的内容的示例:

http://www.google.com
http://www.yahoo.com
http://www.etc.com`

理想情况下，我有兴趣查看是否可以使用通用Windows XP环境"中提供的任何脚本工具将其删除.

如果Windows无法将其削减，最快的&是什么?最简单的解决方案?

是否存在可以进行模式匹配或正则表达式来解析文件的网站或程序，从而进行搜索和搜索?在安装Active Perl或Strawberry Perl之类的东西之前，先替换一下，并为其编写脚本.

解决方案

如果您拥有Excel，则可以很容易地将文本拆分为列

• 上.鉴于格式(字段顺序)始终相同，您应该将URL放在最后一列附近.

  I want to scrape all of the url's out of my .json bookmark backup that firefox creates and output a .txt file.

  Here's a sample of one of the objects located in the file:

  {"index":1,"title":"Bookmarks Toolbar","id":3,"parent":1,"dateAdded":1219177758531250,"lastModified":1288873459187000,"annos":[{"name":"bookmarkProperties/description","flags":0,"expires":4,"mimeType":null,"type":3,"value":"Add bookmarks to this folder to see them displayed on the Bookmarks Toolbar"}],"type":"text/x-moz-place-container","root":"toolbarFolder","children":[{"title":"","id":25,"parent":3,"dateAdded":1224693644437500,"lastModified":1236888979406250,"annos":[{"name":"placesInternal/GUID","flags":0,"expires":4,"mimeType":null,"type":3,"value":"{f6066e21-10ff-46a2-af7a-2891f8dca345}0"}],"type":"text/x-moz-place","uri":"http://www.google.com/"}
  

  These objects are comma-separated and should all contain at least one member that contains a string whose value is the url of the bookmark.

  Here's a sample of what the .txt file would have in it:

  http://www.google.com
  http://www.yahoo.com
  http://www.etc.com`
  

  Ideally, I'm interested in seeing if this can be pulled off using any scripting tools available within a generic Windows XP "environment".

  If Windows can't cut it, what would be the quickest & easiest solution to this?

  Is there a website or program that can do pattern matching or regex to parse the file do search & replace before I go install something like Active Perl or Strawberry Perl and write a script for it.

  解决方案

  If you have Excel, it's probably easy to do a text to columns split

  • http://office.microsoft.com/en-us/excel-help/split-names-by-using-convert-text-to-columns-HA001149851.aspx

  on ". Given the format (order of fields) is always the same, you should have the URLs somewhere near the last column.

  这篇关于解析Mozilla FireFox JSON文件的快速而肮脏的方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！