How to remove the quotation and string characters from string.

[Eric Li]

How to remove the quotation and string characters from a string?
I would like remove the "flavor": in v6 and get the number after that.
The code gen Flavor = subinstr(v6,`"userId":", "", .) doesn't work.

Thanks.

[Nick Cox]

Please note from Statalist FAQ Advice #12 that screenshots are less helpful than you might hope. Please use dataex as explained there. Your example would be solved by

 gen wanted = real(substr(var1, 1 + strpos(var1, ":"), .))

so you look for the colon : and take off what follows, converting it to numeric.