使用SED工具在is_staff:true条件下删除对应JSON代码块是否可行？

当然可以用SED搞定这个需求！不过得先提一句：SED本质是行文本处理工具，对结构化的JSON来说，它的处理效果完全依赖你的文件格式是否严格固定。如果你的JSON和示例格式完全一致（每个对象单独从{ "model":开头行开始，到},结尾行结束，且"is_staff": true明确在fields字段下），那SED完全能胜任；要是JSON的换行、格式有变化，更推荐用jq这种专门处理JSON的工具，容错性强得多。

SED实现命令 #

sed -n '/^{ "model":/,/},$/{ /"is_staff": true/{ :a; N; /},$/!ba; d; }; p; }' input.json > output.json

命令逻辑拆解 #

• -n：让SED默认不输出任何行，只输出我们明确指定要保留的内容
• /^{ "model":/,/},$/：精准定位每个完整的JSON对象块——从以{ "model":开头的行，到以},结尾的行
• /"is_staff": true/{ :a; N; /},$/!ba; d; }：如果当前对象块里包含"is_staff": true这一行，就把整个对象块的内容全部读取进来（N追加下一行，:a和!ba循环直到匹配到结尾的},），然后用d删除整个块
• p：如果对象块里没找到"is_staff": true，就输出这个块的内容

更靠谱的替代方案：jq #

如果你的JSON格式可能有变动（比如换行不固定、字段缩进变化），强烈推荐用jq，它会真正解析JSON结构，不会因为格式细节出错：

jq 'map(select(.fields.is_staff != true))' input.json > output.json

这个命令的逻辑很直观：遍历数组里的每个对象，只保留fields.is_staff不等于true的对象，输出新的JSON数组。

示例对比 #

输入示例 #

[
  {
    "model": "accounts.account",
    "pk": 2,
    "fields": {
      "password": "pbkdf2_sha256$320000$5vD4W5YDuvMmyyVRN5ub6U$weJzPTlN1Hrd7dlpjeO2Lw29a8ej+60Ib09vEifi4Qk=",
      "last_login": "2022-09-08T14:20:45.106Z",
      "is_superuser": false,
      "licence": "dde0af69-154a-4b8c-b393-bd59730b5947",
      "email": "account_admin@bk.ai",
      "first_name": "Marco",
      "last_name": "Rossi",
      "piva": "02375050511",
      "is_active": true,
      "is_staff": false,
      "date_joined": "2022-09-07T14:10:22.456Z",
      "groups": [ 1 ],
      "user_permissions": []
    }
  },
  {
    "model": "accounts.account",
    "pk": 1,
    "fields": {
      "password": "pbkdf2_sha256$320000$mh3UDxtwhiROEecrz8XH3o$NmqWo9epps2EQnYYTe8bKm72HqfHImxUE/eVSZWQ/1U=",
      "last_login": "2022-09-09T13:54:09.498Z",
      "is_superuser": true,
      "licence": null,
      "email": "admin@bk.ai",
      "first_name": "",
      "last_name": "",
      "piva": "",
      "is_active": true,
      "is_staff": true,
      "date_joined": "2022-09-07T14:05:03.213Z",
      "groups": [],
      "user_permissions": []
    }
  },
  {
    "model": "accounts.account",
    "pk": 3,
    "fields": {
      "password": "pbkdf2_sha256$320000$n4PRBAgTo8AejcTf66LTEr$SxhmWFvIcf+gWDyzNXpWz0MrfjemaX1a2msBxUZNvBc=",
      "last_login": null,
      "is_superuser": false,
      "licence": "dde0af69-154a-4b8c-b393-bd59730b5947",
      "email": "account_viewer@bk.ai",
      "first_name": "Alessandro",
      "last_name": "Bianchi",
      "piva": "",
      "is_active": true,
      "is_staff": false,
      "date_joined": "2022-09-07T14:11:39.207Z",
      "groups": [ 3 ],
      "user_permissions": []
    }
  }
]

输出示例 #

[
  {
    "model": "accounts.account",
    "pk": 2,
    "fields": {
      "password": "pbkdf2_sha256$320000$5vD4W5YDuvMmyyVRN5ub6U$weJzPTlN1Hrd7dlpjeO2Lw29a8ej+60Ib09vEifi4Qk=",
      "last_login": "2022-09-08T14:20:45.106Z",
      "is_superuser": false,
      "licence": "dde0af69-154a-4b8c-b393-bd59730b5947",
      "email": "account_admin@bk.ai",
      "first_name": "Marco",
      "last_name": "Rossi",
      "piva": "02375050511",
      "is_active": true,
      "is_staff": false,
      "date_joined": "2022-09-07T14:10:22.456Z",
      "groups": [ 1 ],
      "user_permissions": []
    }
  },
  {
    "model": "accounts.account",
    "pk": 3,
    "fields": {
      "password": "pbkdf2_sha256$320000$n4PRBAgTo8AejcTf66LTEr$SxhmWFvIcf+gWDyzNXpWz0MrfjemaX1a2msBxUZNvBc=",
      "last_login": null,
      "is_superuser": false,
      "licence": "dde0af69-154a-4b8c-b393-bd59730b5947",
      "email": "account_viewer@bk.ai",
      "first_name": "Alessandro",
      "last_name": "Bianchi",
      "piva": "",
      "is_active": true,
      "is_staff": false,
      "date_joined": "2022-09-07T14:11:39.207Z",
      "groups": [ 3 ],
      "user_permissions": []
    }
  }
]

内容的提问来源于stack exchange，提问作者browser-bug