Trim leading and trailing space from Json string

Question

I have a json string like below {"customerCode":xxx,"shippingAmount":9.0,"shippingMethod":" Ground ","customerAddress":{"line1":" 1595 Spring Hill rd ","line2":"ste I want to trim the leading space and trailing space in the json string. I used regex but doesn't seems to be working.

Sreekanth Reddy · Answer

Umesh : We are having only 2 options : 1 is from the sender(can be you server side code lik php or java or .Net) itself it should come by trimming. Another is we needs to trim after doing parse, which I had provided code in previous posts. Thank you.

Umesh Kumar · Answer

The place where I have this function to convert is an common code and the Json input to that function can different based on different ndpoint so our converter has to be generic. Below is my code var rgx = Regex.Replace(str, @"\s+\Z", ""); var nb= Regex.Replace(str, @"\s(?=([^""]*""[^""]*"")*[^""]*$)", string.Empty); My situation is let say you have a json key value like this {"Customer":"Value " } should trim and give me {"Customer":"Value" } {"Customer":" Value " } should trim and give me {"Customer":"Value" } {"Customer":"Value 1 " } should trim and give me {"Customer":"Value 1" } Only leading and trailing space should be trimmed

Sreekanth Reddy · Answer

Hi Umesh Kumar, It's not possible directly with Json format. You needs to parse for sure. If it solves mark as answer. Or come up with your query. Thank you.

Umesh Kumar · Answer

Do we have any option with Newtonsoft.Json

Sreekanth Reddy · Answer

Hi Umesh Kumar, we can't do trim while it was in Json text format. Do parseing by javascript var lstis = Json.parse('{"customerCode":xxx,"shippingAmount":9.0,"shippingMethod":" Ground ","customerAddress":{"line1":" 1595 Spring Hill rd ","line2":"ste.... '); Now use the trim() function while accessing the data. var valaftertrim = lstis["shippingMethod"].trim(); console.log(valaftertrim); Please mark as accepted answer if it solves else come up with a query. Thank you.