regex101: json-extract

*the literal (32₁₀ / 40₈ / 20₁₆) , repeated any number of times

"the literal " (34₁₀ / 42₈ / 22₁₆)

Group 1(\w+)

\w+any word character, repeated at least once

": the literal text ":

Group 2("?[^,"]*"?)

"?optionally matches the literal " (34₁₀ / 42₈ / 22₁₆)

Negated Character Class[^,"]*

*matches any number of characters outside the set below:

,the literal , (44₁₀ / 54₈ / 2C₁₆)

"the literal " (34₁₀ / 42₈ / 22₁₆)

"?optionally matches the literal " (34₁₀ / 42₈ / 22₁₆)

Character Class[,|,\n]

,the literal , (44₁₀ / 54₈ / 2C₁₆)

|the literal | (124₁₀ / 174₈ / 7C₁₆)

\na line-feed (newline) character (ASCII 10)

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Search reference

Regular Expression

 *"(\w+)": ("?[^,"]*"?)[,|,\n]

New

      "ID": 26,
      "MenuName": "测点数据管理",
      "PLevel": 2,
      "Url": "pages/datamanage/sensor_group/index.html",
      "NewTab": 0,
      "IconName": "",
      "ParentID": 23,
      "OrderBy": 5,
      "Remark": "",
      "MenuType": 2,
      "RoleID": 1,
      "PagePower": 1,
      "MenuID": "26",
          "ButtonName": "添加数据",
          "ButtonID": "addSensorOrgData",
          "FunctionName": "addSensorOrgDataByID",
          "FunctionController": "sensordata",
          "OrderBy": 5,
          "RoleID": 1,
          "MenuType": 3,
          "MenuID": 1,
          "ParentID": 26,
          "MenuName": "添加数据",
          "PagePower": 1

Regular Expressions 101

Regular Expression

Substitution