Help with RegexExtract in Google Sheets

[Celia Machado]

Hi folks! Could use some help:
Working with GSheets
I have a list containing 100-1000 lines with the following structure.

[{"name":"VASILISA","id":"Xlkjhalksduylk71661","subs":121121}, {"name":"PEDROS","id":"90870398472lkjljssss","subs":1211}, {"name":"ActionAFool","id":"ljkhlkjhlkj798798lkjhljk","subs":59400}, {"name":"OROMERO","id":"080980lkl-8uR7w","subs":44}]

In this example, there are 4 name, id and subs. This amount, however, can be different: from 1 to 10-15.
I need somehow to extract NAME, ID, and SUBS into separate columns.
Screenshot attached.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Help with RegexExtract
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Celia Machado]

Can anyone help please?

 

[Celia Machado]

???