How to remove space from the JSON (String) value in C#?

Question

Asked 4 years, 1 month ago

Viewed 341 times

1

I have the following JSON stored in a String variable:

{"novosPedidos":[],"pedidos":[{"Apagar":" 633.56"}]}

The "Delete" value contains a space which I need to remove.

I tried using the Replace() method but did not get the expected result:

var newJson = json.Replace(":\" ", ":\"");

The newJson "Delete" value remained unchanged (with space).

I also tried using Replace() replacing only space, but it didn’t work:

var newJson = json.Replace(" ", "");

I copied EXACTLY the Original JSON and a strange character appeared in place of space. I could not identify anything. How to solve?

Here is working https://ideone.com/ddaSu6.

– Andre

2020/05/18 at 15:43
I copied the String straight from the original JSON and ran a test on Ideone. The funny thing that there instead of being showing an empty space, is a "point" highlighted. Is that some kind of break? https://ideone.com/W6rAqE

– felipearon

2020/05/18 at 17:50
Because it does not use the var newJson = json.Replace(" ", "");?

– CypherPotato

2020/05/18 at 18:11
Cypher, see the example here that I set up - https://ideone.com/W6rAqE for some reason some strange special character that I can’t identify. Ali is not really containing space...

– felipearon

2020/05/18 at 18:17

1 answer

Browser other questions tagged c# json replace

You are not signed in. Login or sign up in order to post.

by mgiurni • 36 points · Answer 1 · 2020-05-21T20:33:30+00:00

The character you are trying to replace is not a space, but a hard space (non-breaking space).

So just replace your Unicode code ( u00A0):

var newJson = json.Replace(":\"\u00A0", ":\"");

To find the decimal value of the character, just convert it:

Console.WriteLine((int)(' '));

The result is 160, which represents the hard space in the ASCII table.

You will also be able to remove this space using Regex:

Regex.Replace(json, @"[:][""]\s+", ":\"");