python 保存json时最后一个多了一个逗号_JSON从最后一个对象中删除尾随逗号

This JSON data is being dynamically inserted into a template I'm working on. I'm trying to remove the trailing comma from the list of objects.

The CMS I'm working in uses Velocity, which I'm not too familiar with yet. So I was looking to write a snippet of JavaScript that detects that trailing comma on the last object (ITEM2) and removes it. Is there a REGEX I can use to detect any comma before that closing bracket?

[

{

"ITEM1":{

"names":[

"nameA"

]

}

},

{

"ITEM2":{

"names":[

"nameB",

"nameC"

]

}

}, // need to remove this comma!

]

解决方案

You need to find ,, after which there is no any new attribute, object or array.

New attribute could start either with quotes (" or ') or with any word-character (\w).

New object could start only with character {.

New array could start only with character [.

New attribute, object or array could be placed after a bunch of space-like symbols (\s).

So, the regex will be like this:

let regex = /\,(?!\s*?[\{\[\"\'\w])/g;

Use it like this:

// javascript

let input; // this is the initial string of data

let correct = input.replace(regex, ''); // remove all trailing commas

let data = JSON.parse(correct); // build a new JSON object based on correct string

Another approach is to find every ,, after which there is a closing bracket.

Closing brackets in this case are } and ].

Again, closing brackets might be placed after a bunch of space-like symbols (\s).

Hence the regexp:

let regex = /\,(?=\s*?[\}\]])/g;

Usage is the same.