javascript fix json with regex

Question

Hi All I want to fix my json I got strings without " and I need to bring them back somehow I have found a regex that find some of the texts but still its not returning the right result

 var newString2 = j.replace(/[a-zA-Z0-9@.,_+]*[^:][\w]/g, function(x){
      return '"'+x+'"';

    });

my json

{
  User_Story_UI_24: 
   {
     Env:Staging,
     UserName:[email protected],
     Password: User@SDF45sdfg,
     Supplier:Xxxxx,
     SupplierWebSite:www.xxxx.com,
     SupplierPhone:+111 2223334440,
     SupplierAddress:sss asf21, asf asf, saf
   }
}

the epcepted result

{
  "User_Story_UI_24": 
   {
     "Env":"Staging",
     "UserName":"[email protected]",
     "Password": "User@SDF45sdfg",
     "Supplier":"Xxxxx",
     "SupplierWebSite":"www.xxxx.com",
     "SupplierPhone":"+111 2223334440",
     "SupplierAddress":"sss asf21, asf asf, saf"
   }
}

@mrzasa I think the values under User_Story_UI_24 should be within single or double quotes, is what I understood — shrys
– shrys, Commented Jul 18, 2019 at 12:06
Where are you seeing this JSON? How is it created / sent? "Fixing a JSON" just seems like a bad idea. — Austin T French
– Austin T French, Commented Jul 18, 2019 at 12:08
I can't fix the string its cam from groovy pipeline on jenkins as a parameter — shaharnakash
– shaharnakash, Commented Jul 18, 2019 at 12:09

GalAbra · Accepted Answer · 2019-07-18 13:07:20Z

1

I've used a regex that detects the lines in your regex (assuming it's in the same format as in your example).
Then it uses a function that receives the matching groups as its parameters and creates two quoted strings accordingly.

The only change I made to your input was adding a comma after the last property, to keep all the lines in the same format:

const input = `{
  User_Story_UI_24: 
   {
     Env:Staging,
     UserName:[email protected],
     Password: User@SDF45sdfg,
     Supplier:Xxxxx,
     SupplierWebSite:www.xxxx.com,
     SupplierPhone:+111 2223334440,
     SupplierAddress:sss asf21, asf asf, saf,
   }
}`;

let ans = input.replace(/(\w+?): ?([+\w @.,]+),/g, (row, prop, value) => {
  return `"${prop}": "${value}",`;
});
console.log(ans);

edited Jul 18, 2019 at 13:07

answered Jul 18, 2019 at 12:17

GalAbra

5,1585 gold badges25 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

shaharnakash Over a year ago

ammm almost what about the User_Story_UI?

GalAbra Over a year ago

I'm afraid it has to be modified using a separate regex, as it doesn't follow the same format and therefore the replacing function will be missing a parameter. BTW the JSON is valid without properties being wrapped in quotes

shaharnakash Over a year ago

need to erase the comma in the last parameter

Collectives™ on Stack Overflow

javascript fix json with regex

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related