Databases
StackOverflow2013
Postsdbo
POReplace double quotes in json string with empty string
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POReplace double quotes in json string with empty string
    primarykey
    data
    text
    <p>I have problem with deserialization of json string, because string is bad format.</p> <p>For example json object consist string property statusMessage with value "Hello <strong>"dog"</strong> ".</p> <p>The correct format should be "Hello <strong>\" dog \"</strong> " .</p> <p>I would like remove double quotes from this property.</p> <p>Something Like this. "Hello <strong>"dog"</strong> ". -> "Hello dog ".</p> <p>Here is it original json string which I work.</p> <pre><code>"{\"jancl\":{\"idUser\":18438201,\"nick\":\"JANCl\",\"photo\":\"1\",\"sex\":1,\"photoAlbums\":1,\"videoAlbums\":0,\"sefNick\":\"jancl\",\"profilPercent\":75,\"emphasis\":false,\"age\":\"-\",\"isBlocked\":false,\"PHOTO\":{\"normal\":\"http://u.aimg.sk/fotky/1843/82/n_18438201.jpg?v=1\",\"medium\":\"http://u.aimg.sk/fotky/1843/82/m_18438201.jpg?v=1\",\"24x24\":\"http://u.aimg.sk/fotky/1843/82/s_18438201.jpg?v=1\"},\"PLUS\":{\"active\":false,\"activeTo\":\"0000-00-00\"},\"LOCATION\":{\"idRegion\":\"6\",\"regionName\":\"Trenčiansky kraj\",\"idCity\":\"138\",\"cityName\":\"Trenčianske Teplice\"},\"STATUS\":{\"isLoged\":true,\"isChating\":false,\"idChat\":0,\"roomName\":\"\",\"lastLogin\":1294925369},\"PROJECT_STATUS\":{\"photoAlbums\":1,\"photoAlbumsFavs\":0,\"videoAlbums\":0,\"videoAlbumsFavs\":0,\"videoAlbumsExts\":0,\"blogPosts\":0,\"emailNew\":0,\"postaNew\":0,\"clubInvitations\":0,\"dashboardItems\":1},\"STATUS_MESSAGE\":{\"statusMessage\":\"\"Status\"\",\"addTime\":\"1294872330\"},\"isFriend\":false,\"isIamFriend\":false}}" </code></pre> <p>Problem is here, json string consist this object:</p> <pre><code>"STATUS_MESSAGE": {"statusMessage":" "some "bad" value" ", "addTime" :"1294872330"} </code></pre> <p>Condition of string which I want modified:</p> <ul> <li>string start with <strong>"statusMessage":"</strong></li> <li>string can has any *<em>lenght from 0 -N *</em></li> <li>string end with <strong>", "addTime</strong></li> </ul> <p>So I try write pattern for string which start with "statusMessage":", has any lenght and is ended with ", "addTime.</p> <p>Here is it:</p> <pre><code> const string pattern = " \" statusMessage \" : \" .*? \",\"addTime\" "; var regex = new Regex(pattern, RegexOptions.IgnoreCase); //here i would replace " with empty string string result = regex.Replace(jsonString, match =&gt; ???); </code></pre> <p>But I think pattern is wrong, also I don’t know how replace double quotes with empty string (remove double quotes).</p> <p>My goal is :</p> <pre><code>"statusMessage":" "some "bad" value" </code></pre> <p>to <code>"statusMessage":" "some bad value"</code> </p> <p>Thank for advice</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USGreg
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POReplace double quotes in json string with empty string
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POReplace double quotes in json string with empty string
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POReplace double quotes in json string with empty string
      1. USfranklins
      1. VTFavorite
    1. COI assume there's absolutely no chance of fixing the data source itself? I usually find that by the time a machine-generated string is shown to be in a bad format, I don't trust the source not to mess up things I haven't seen. This is particularly true of XML - a data source which serves malformed XML is usually not taking the sane approach of using an XML API, which makes me wonder where else their sanity is lacking. I would view JSON in the same way.
      singulars
      1. POReplace double quotes in json string with empty string
      1. USJon Skeet
    2. COIf the strings can contain colons and commas (`:`, `,`), which is very likely, I don't think the problem is solvable - you can miss whole keys and values, or create excess ones.
      singulars
      1. POReplace double quotes in json string with empty string
      1. USKobi
    3. CO@Jon Skeet: I haven’t any chance to correct json format on server, I think use regExp is only the one solution. Because I need deserialize this json to CLR object, so firts must be json string in correct format. I am not friendly with regex, json scope. If you can help me I would be glad.
      singulars
      1. POReplace double quotes in json string with empty string
      1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload