主页 / coding / 问题 / 77956650
Accepted
Ahmad Ismail
Asked: 2024-02-08 01:05:09 +0800 CST

使用正则表达式和 jq 替换 json 的部分值

  • 772

我有一个如下所示的 json：

[
  {
    "name": "architecture-design-detailed",
    "rootPath": "/media/ismail/architecture-design-detailed/_Working/_NotesFiltered/_software/architecture-design-detailed",
    "paths": [],
    "group": "",
    "enabled": true
  },
  {
    "name": "architecture-design-detailed-engineering",
    "rootPath": "/media/ismail/architecture-design-detailed/_Working/_NotesFiltered/_software/architecture-design-detailed-engineering",
    "paths": [],
    "group": "",
    "enabled": true
  }
]

如果名字是architecture-design-detailed,

  • 将名称更改为new_name_here

  • 用 new_name_here 替换 rootPath 的最后一部分（这是架构设计详细的，在最后一个 / 之后）。

所以预期的输出是：

[
  {
    "name": "new_name_here",
    "rootPath": "/media/ismail/architecture-design-detailed/_Working/_NotesFiltered/_software/new_name_here",
    "paths": [],
    "group": "",
    "enabled": true
  },
  {
    "name": "architecture-design-detailed-engineering",
    "rootPath": "/media/ismail/architecture-design-detailed/_Working/_NotesFiltered/_software/architecture-design-detailed-engineering",
    "paths": [],
    "group": "",
    "enabled": true
  }
]

到目前为止我想到的是：

jq 'map(if .name == "architecture-design-detailed" then .name = "new_name_here" else . end)'

但不明白如何替换 rootPath 的最后一部分。我认为我们必须使用subor gsub。但不明白如何。

jq

3 个回答

  1. Best Answer

    您可以使用split("/")转换rootPath为数组，然后将最后一个索引 ( .[-1]) 设置为new_name，然后将join("/")它们重新组合在一起。

    我们使用|=insidemap()来更新由 找到的对象select()，然后.name根据rootPath需要进行覆盖。

    map(select(.name == "architecture-design-detailed") 
    |= ( 
        .name = "new_name",
        .rootPath = (.rootPath | split("/") | .[-1] = "new_name" | join("/"))
    ) 
)

    [
  {
    "name": "new_name",
    "rootPath": "/media/ismail/architecture-design-detailed/_Working/_NotesFiltered/_software/new_name",
    "paths": [],
    "group": "",
    "enabled": true
  },
  {
    "name": "architecture-design-detailed-engineering",
    "rootPath": "/media/ismail/architecture-design-detailed/_Working/_NotesFiltered/_software/architecture-design-detailed-engineering",
    "paths": [],
    "group": "",
    "enabled": true
  }
]

    JqPlay演示

    • 1

  2. 为了使用 jq 实现您的目标，当名称匹配“architecture-design-detailed”时，您确实需要使用 sub 函数来替换 rootPath 的最后部分。除了更改名称之外，您的 jq 过滤器还需要扩展以有条件地修改 rootPath。

    map(
  if .name == "architecture-design-detailed" then
    .name = "new_name_here" |
    .rootPath |= sub("/architecture-design-detailed$"; "/new_name_here")
  else
    .
  end
)

    输出：

    [
  {
    "name": "new_name_here",
    "rootPath": "/media/ismail/architecture-design-detailed/_Working/_NotesFiltered/_software/new_name_here",
    "paths": [],
    "group": "",
    "enabled": true
  },
  {
    "name": "architecture-design-detailed-engineering",
    "rootPath": "/media/ismail/architecture-design-detailed/_Working/_NotesFiltered/_software/architecture-design-detailed-engineering",
    "paths": [],
    "group": "",
    "enabled": true
  }

    ]

    • 1

  3. 这是另一种方法，它通过使用 右修剪旧名称来立即.name, .rootPath更新所选项目匹配的两个字段，然后使用 添加新名称：.name == $fromrtrimstr($from)+ $to

    jq --arg from 'architecture-design-detailed' --arg to 'new_name_here' '
  map((select(.name == $from) | .name, .rootPath) |= rtrimstr($from) + $to)
'

    [
  {
    "name": "new_name_here",
    "rootPath": "/media/ismail/architecture-design-detailed/_Working/_NotesFiltered/_software/new_name_here",
    "paths": [],
    "group": "",
    "enabled": true
  },
  {
    "name": "architecture-design-detailed-engineering",
    "rootPath": "/media/ismail/architecture-design-detailed/_Working/_NotesFiltered/_software/architecture-design-detailed-engineering",
    "paths": [],
    "group": "",
    "enabled": true
  }
]
    • 0

相关问题