Remove words outside quotation marks with RegEx

I am attempting to use RegEx to remove all of the information outside of where it says Sales.

Sometimes the word inside the quotation will be something other than Sales, it could be Marketing, Engineering, etc.

[{"id":4007585002,"name":"Sales","child_ids": [4053985002,4036350002,4036349002],"parent_id":null}]

Any thoughts on how I should write the RegEx?

I used expand JSON. You can close this.

1 Like