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!

gautiergodard

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

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

New Workflow3.yxmd