JSON insert and replace characters in js or python

Question

I have JSON file which has array of 500 objects that looks like this:

{
  "books":[
    {
      "title":"Title 1",
      "year":"2012",
      "authors":"Jack ; George",
      },
    {
      "title":"Title 2",
      "year":"2010",
      "authors":"Leonard ; Robin",
      },
    ...

How can i loop through this file in js or python and change "authors" of every object to look like this:

"authors":["Jack" , "George"]

Thank you.

Answer 1

You need just to split your authors by ;. Call also trim on each author to remove the extra spaces.

const books = [
    {
      "title":"Title 1",
      "year":"2012",
      "authors":"Jack ; George",
    },
    {
      "title":"Title 2",
      "year":"2010",
      "authors":"Leonard ; Robin",
    }
];

books.forEach(item =>  {
   item.authors = item.authors.split(';')
                              .map(author => author.trim());
});

console.log(books);

Answer 2

I think this code snippet should do the needful.

var obj = {
  "books":[
    {
      "title":"Title 1",
      "year":"2012",
      "authors":"Jack ; George",
      },
    {
      "title":"Title 2",
      "year":"2010",
      "authors":"Leonard ; Robin",
      }]
  };
for(var i in Object.keys(obj.books)){
  obj.books[i].authors = obj.books[i].authors.split(" ; ")
  


}

Answer 3

If your using python, you can try this:

data = {
    "books":[
      {
       "title":"Title 1",
       "year":"2012",
       "authors":"Jack ; George",
      },
      {
       "title":"Title 2",
       "year":"2010",
       "authors":"Leonard ; Robin",
      }
    ]
   }

for k1 in data:
    for k2 in data[k1]:
        k2['authors'] = [x.strip() for x in k2['authors'].split(';')]

print(data)

Which Outputs:

{'books': [{'title': 'Title 1', 'year': '2012', 'authors': ['Jack', 'George']}, {'title': 'Title 2', 'year': '2010', 'authors': ['Leonard', 'Robin']}]}

Answer 4

Try this:-

for i in a["books"]:
    i['authors'] = [x.strip() for x in (i['authors'].split(";"))]
print(a)  #your output