Trim leading and trailing space from Json string

Umesh Kumar

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.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sreekanth Reddy7y ago
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 Kumar7y ago
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 Reddy7y ago
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 Kumar7y ago
Do we have any option with Newtonsoft.Json
Sreekanth Reddy7y ago
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.