Vasili
New member
- Joined
- May 18, 2021
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- google sheets
Hi folks! Could use some help:
Working with GSheets
I have a list containing 100-1000 lines with the following structure.
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.
thanks!
Working with GSheets
I have a list containing 100-1000 lines with the following structure.
Code:
[COLOR=#5A5E68][FONT='inherit'][{"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}][/FONT][/COLOR]
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.
thanks!