Replace Double Double Quotes in UTF-8 String to single Double quotes

Question

I have string that is formatted in UTF-8.

"{""messages"":[{""messageId"":""245043"",""campaignId"":""14085""

I need to replace the double double quotes to single double quotes.

The following is able to replace double quotes to double single quotes

        NewMessage = Replace(Message, "““", "''")

But I can't figure out how to replace the double double quotes to single double quotes.

The code was written in vb.net and the desired output is:

"{"messages":[{"messageId":"245043","campaignId":"14085"

Added image from watch

Solution Provided by o_O

That looks like JSON - if so, are you sure you want to fiddle with it manually...or that it actually comes that way? — Ňɏssa Pøngjǣrdenlarp, Sep 15 '17 at 15:59
First replace single [double quotes] with single [single quotes]. Then replace double [single qoutes] to single [double quotes] and then if any [single qoute] is left, replace it with [double qoute] — boop_the_snoot, Sep 15 '17 at 17:31
It didn't work and I think the reason is the encoding of the string. I tried both with simple replace and using CHR as well. — Internet Engineer, Sep 15 '17 at 17:44
If encoding might be the issue, check similar posts like [this](https://stackoverflow.com/questions/1922199/c-sharp-convert-string-from-utf-8-to-iso-8859-1-latin1-h) — boop_the_snoot, Sep 15 '17 at 17:48
This is a mistake, you are being mislead by the way the debugger displays strings. It makes an effort to show them the way you'd write them in a program. Click the spyglass icon to activate the text visualizer, you'll see that the string does not actually contain doubled double quotes. — Hans Passant, Sep 15 '17 at 19:22

score 0 · Answer 1 · answered Sep 15 '17 at 16:07

0

You can leverage the Chr function for this:

NewMessage = Message.Replace(Chr(34) & Chr(34), Chr(34))

answered Sep 15 '17 at 16:07

NoAlias

9,218
2
27
46

You can't use it or it's not working for you? I just did a test of this and it worked fine. – NoAlias Sep 15 '17 at 16:13
Its not working for me. Tried it before making the post – Internet Engineer Sep 15 '17 at 17:18

score 0 · Answer 2 · answered Sep 15 '17 at 17:40

I assume your data is coming from somewhere in
"{""messages"":[{""messageId"":""245043"",""campaignId"":""14085""
format, so for the sake of the question I'm formatting the input in a proper way:

Dim str As String  =  """{""""messages"""":[{""""messageId"""":""""245043"""",""""campaignId"""":""""14085"""""
Console.WriteLine("Input : " & str)
str = str.Replace("""","'").Replace("''","""").Replace("'","""")
Console.WriteLine("Output : " & str)

Output:

Input : "{""messages"":[{""messageId"":""245043"",""campaignId"":""14085""

Output : "{"messages":[{"messageId":"245043","campaignId":"14085"

Check it on Fiddle

Yes! 100%, your solution works when you provide the string. I will post image of what happens with your solution when applied to my string. — Internet Engineer, Sep 15 '17 at 17:48

Replace Double Double Quotes in UTF-8 String to single Double quotes

2 Answers2