how do I remove " from string?

[DFstr]

"Hi, I need help with editing a text. I want to remove quotation marks from some numbers, but not from other parts. Here's an example of what I have:

"type": "text", "id": "761", "formId": "2052", "label": "mail",

And here's what I want it to look like:

"type": "text", "id": 761, "formId": 2052, "label": "mail

Using replace characher tool is not an option, hence I was trying to replace :

"id": " with  "id": 

", "formId": " with ", "formId": 

, "label" with , label"

 I tried to use following method: :

• Replace "id": " with "id":
• Replace ", "formId": " with ", "formId":
• Replace , "label" with , label

But when I use Replace([JSON_ValueString], """id": """, ""id": "), I am getting error message ("malformed statemet "

"

Replace([JSON_ValueString], """id": """, ""id": ") - is malformed statemet 

How can I do this without errors?

Thanks!

[TimN]

I found this -

https://superuser.com/questions/753119/remove-quotation-marks-around-a-number-while-leaving-other-qu...

Tried it and seems to work.

[gautiergodard]

Hello @DFstr 

Please see solution attached, using regex.

[DFstr]

this won´t do the job, as I have another spots where I need to have number between double quotes. E.g. "imageChoices_showLabels": "1", needs to stay as it is

[gautiergodard · Accepted solution]

No problem @DFstr , here is another way to do it!

Please mark this post as solution if it solved your problem!

[DFstr]

Thanks!