excel

[redbull2k]

i have done some experimenting with JSON a while ago maybe this can help to some degree, the api is free to use with JSON
Function Function10

Code:

Copy      Help

str JSON="{''member'':{''userid'':'''',''adult'':''1''},''config'':{''noneAdultChk'':''N''},''list'':[{''idx'':''23044815'',''req'':''0'',''adult'':''N'',''ad_copy'':'''',''color'':'''',''bold'':'''',''title'':''\ud0ac\uc787.E03.190330.720p-NEXT'',''ortitle'':'''',''comment'':''0'',''hd'':''Y'',''mobile'':''0'',''size'':''1.3G'',''realsize'':''1414740338'',''point'':''1500'',''catecode'':''BD_DM_04'',''catename'':''\ubbf8\ub2c8\uc2dc\ub9ac\uc988'',''nickname'':''\uc0c9\ub9c8\ud604\uc11d'',''passnick'':''f2b112b190b1n1b172b152b190b122b1'',''chkcopy'':''Y'',''chkcopy_set'':''Y'',''filecrack'':'''',''discount'':''''},{''idx'':''23044419'',''req'':''0'',''adult'':''N'',''ad_copy'':'''',''color'':'''',''bold'':'''',''title'':''[\uc911\ub4dc] \ud0dd\ucc9c\uae30 36\ud654-40\ud654'',''ortitle'':'''',''comment'':''0'',''hd'':''Y'',''mobile'':''1'',''size'':''3.1G'',''realsize'':''3326335028'',''point'':''7500'',''catecode'':''BD_DM_03'',''catename'':''\uc911\uad6d\ub4dc\ub77c\ub9c8'',''nickname'':''dfca11'',''passnick'':''86b186b1q4b1o4b1l4b1n4b1'',''chkcopy'':''Y'',''chkcopy_set'':''Y'',''filecrack'':'''',''discount'':''''},{''idx'':''23044796'',''req'':''0'',''adult'':''N'',''ad_copy'':'''',''color'':'''',''bold'':'''',''title'':''\uc5f4\ud608\uc0ac\uc81c 27-28\ud68c \ud569\ubcf8.E14.190330.720p-NEXT'',''ortitle'':'''',''comment'':''0'',''hd'':''Y'',''mobile'':''0'',''size'':''1.3G'',''realsize'':''1348751510'',''point'':''1500'',''catecode'':''BD_DM_04'',''catename'':''\ubbf8\ub2c8\uc2dc\ub9ac\uc988'',''nickname'':''\uc0c9\ub9c8\ud604\uc11d'',''passnick'':''f2b112b190b1n1b172b152b190b122b1'',''chkcopy'':''Y'',''chkcopy_set'':''Y'',''filecrack'':'''',''discount'':''''},{''idx'':''23044782'',''req'':''0'',''adult'':''N'',''ad_copy'':'''',''color'':'''',''bold'':'''',''title'':''\ub9ac\uac08\ud558\uc774.E16.190330.720p-NEXT'',''ortitle'':'''',''comment'':''0'',''hd'':''Y'',''mobile'':''0'',''size'':''1.5G'',''realsize'':''1597730865'',''point'':''100'',''catecode'':''BD_DM_04'',''catename'':''\ubbf8\ub2c8\uc2dc\ub9ac\uc988'',''nickname'':''\uc0c9\ub9c8\ud604\uc11d'',''passnick'':''f2b112b190b1n1b172b152b190b122b1'',''chkcopy'':''Y'',''chkcopy_set'':''Y'',''filecrack'':'''',''discount'':100},{''idx'':''23044417'',''req'':''0'',''adult'':''N'',''ad_copy'':'''',''color'':'''',''bold'':'''',''title'':''[\uc911\ub4dc] \ud0dd\ucc9c\uae30 31\ud654-35\ud654'',''ortitle'':'''',''comment'':''0'',''hd'':''Y'',''mobile'':''1'',''size'':''3.4G'',''realsize'':''3642414529'',''point'':''7500'',''catecode'':''BD_DM_03'',''catename'':''\uc911\uad6d\ub4dc\ub77c\ub9c8'',''nickname'':''dfca11'',''passnick'':''86b186b1q4b1o4b1l4b1n4b1'',''chkcopy'':''Y'',''chkcopy_set'':''Y'',''filecrack'':'''',''discount'':''''},{''idx'':''23044415'',''req'':''0'',''adult'':''N'',''ad_copy'':'''',''color'':'''',''bold'':'''',''title'':''[\uc911\ub4dc] \ud0dd\ucc9c\uae30 26\ud654-30\ud654'',''ortitle'':'''',''comment'':''0'',''hd'':''Y'',''mobile'':''1'',''size'':''3.4G'',''realsize'':''3697815036'',''point'':''7500'',''catecode'':''BD_DM_03'',''catename'':''\uc911\uad6d\ub4dc\ub77c\ub9c8'',''nickname'':''dfca11'',''passnick'':''86b186b1q4b1o4b1l4b1n4b1'',''chkcopy'':''Y'',''chkcopy_set'':''Y'',''filecrack'':'''',''discount'':''''},{''idx'':''23044414'',''req'':''0'',''adult'':''N'',''ad_copy'':'''',''color'':'''',''bold'':'''',''title'':''[\uc911\ub4dc] \ud0dd\ucc9c\uae30 21\ud654-25\ud654'',''ortitle'':'''',''comment'':''0'',''hd'':''Y'',''mobile'':''1'',''size'':''3.4G'',''realsize'':''3699778754'',''point'':''7500'',''catecode'':''BD_DM_03'',''catename'':''\uc911\uad6d\ub4dc\ub77c\ub9c8'',''nickname'':''dfca11'',''passnick'':''86b186b1q4b1o4b1l4b1n4b1'',''chkcopy'':''Y'',''chkcopy_set'':''Y'',''filecrack'':'''',''discount'':''''},{''idx'':''23044410'',''req'':''0'',''adult'':''N'',''ad_copy'':'''',''color'':'''',''bold'':'''',''title'':''[\uc911\ub4dc] \ud0dd\ucc9c\uae30 16\ud654-20\ud654'',''ortitle'':'''',''comment'':''0'',''hd'':''Y'',''mobile'':''1'',''size'':''3.4G'',''realsize'':''3636149673'',''point'':''7500'',''catecode'':''BD_DM_03'',''catename'':''\uc911\uad6d\ub4dc\ub77c\ub9c8'',''nickname'':''dfca11'',''passnick'':''86b186b1q4b1o4b1l4b1n4b1'',''chkcopy'':''Y'',''chkcopy_set'':''Y'',''filecrack'':'''',''discount'':''''},{''idx'':''23044409'',''req'':''0'',''adult'':''N'',''ad_copy'':'''',''color'':'''',''bold'':'''',''title'':''[\uc911\ub4dc] \ud0dd\ucc9c\uae30 11\ud654-15\ud654'',''ortitle'':'''',''comment'':''0'',''hd'':''Y'',''mobile'':''1'',''size'':''3.5G'',''realsize'':''3722536001'',''point'':''7500'',''catecode'':''BD_DM_03'',''catename'':''\uc911\uad6d\ub4dc\ub77c\ub9c8'',''nickname'':''dfca11'',''passnick'':''86b186b1q4b1o4b1l4b1n4b1'',''chkcopy'':''Y'',''chkcopy_set'':''Y'',''filecrack'':'''',''discount'':''''},{''idx'':''23044553'',''req'':''"
;out JSON
Chilkat_v9_5_0.ChilkatJsonObject json25._create
Chilkat_v9_5_0.ChilkatJsonArray ja._create
Chilkat_v9_5_0.ChilkatJsonObject json._create
json25.Load(JSON)
json=0
ja= json25.ArrayOf("list")
int i
for i 0 ja.Size
,json=ja.ObjectAt(i)
,;sel json.StringOf("idx")
,,;case "23044417"
,,out json.StringOf("title")
,,out json.StringOf("catecode")
,,out json.StringOf("nickname")