Regex to replace in json string

Question

Is there a regex expression I can use to find all the numbers in JSON string and replace them within double quotes?

For example in the below JSON string, I want to replace the Id and Phone values with double quotes.

String jsonString = " [ 
{ 
   "FirstName": "abc",  
   "Email" : "[email protected]",
   "Id" : 1,
   "Phone" : 1234567890,
   "Date": "2 May 2016 23:59:59"

}, 
{  
   "FirstName": "xyz",  
   "Email" : "[email protected]",
   "Id" : 2,
   "Phone" : 9876543210,
   "Date": "3 May 2016 23:59:59" 

} 
] ";

I want to get the following output:

[ 
    { 
       "FirstName":"abc",  
       "Email" : "[email protected]",
       "Id" : "1",
       "Phone" : "1234567890",
       "Date": "2 May 2016 23:59:59"

    }, 
    {  
       "FirstName":"xyz",  
       "Email" : "[email protected]",
       "Id" : "2",
       "Phone" : "9876543210",
       "Date": "3 May 2016 23:59:59"  

    } 
    ]

I tried line below but it does not work. Any ideas?

 jsonString = jsonString.replaceAll("=[ ]*([\\d]+)", "= \"$1\"");

Huso · Accepted Answer · 2017-10-25 12:45:44Z

4

You are doing multiple things wrong.

Your regex searches for matches starting with a = instead of :
To capture white(space) use \s

Here is your correct regex: https://regex101.com/r/sRDXMP/2/

And here is your fixed code: jsonString = jsonString.replaceAll(":\\s([\\d]+)", ": \"$1\"");

edited Oct 25, 2017 at 12:45

answered Oct 25, 2017 at 12:38

Huso

1,4869 silver badges14 bronze badges

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

2 Comments

Michael A. Schaffrath Over a year ago

Escaping the backslash itself is not an error, thats Java syntax (unfortunately)

Huso Over a year ago

@MichaelA.Schaffrath thanks, updated the code snippet.

Michael A. Schaffrath · Accepted Answer · 2017-10-25 12:48:08Z

1

Replace the = in your regular expression by :
Also, you should use the whitespace selector instead of [ ].

jsonString = jsonString.replaceAll(":\\s*(\\d+)", ": \"$1\"");

edited Oct 25, 2017 at 12:48

answered Oct 25, 2017 at 12:37

Michael A. Schaffrath

2,1401 gold badge15 silver badges24 bronze badges

2 Comments

Aman Mohammed Over a year ago

I also have a date object. so the : should not be replaced. i have edited my post again.

Michael A. Schaffrath Over a year ago

Then you just need to expect a comma or a right curly bracket after your digits: ":\\s*(\\d+)\s*[,}]"

Paolo fernando Flores Rivera · Accepted Answer · 2025-06-26 22:33:12Z

0

i know its a little bit more typing but if you want to add the exact attributes you want to remove you can also use this regex

 (?<="tlv":")[^"]+(?=")

playground: regex

answered Jun 26 at 22:33

Paolo fernando Flores Rivera

411 silver badge5 bronze badges

Collectives™ on Stack Overflow

Regex to replace in json string

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related