Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
excel
#1
I try to output text that contains certain words after excluding certain keywords.
However, there is no problem when it is a single variable, but when importing Excel's row, the normal result is not output.

The reason is that the "addline" of the "sub function" is causing the problem.

What can I do to resolve this?

Macro Macro2
Code:
Copy      Help
out
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":"0","adult":"N","ad_copy":"","color":"","bold":"","title":"[SD] \uc0ac\uc870\uc601\uc6c5\uc804 2008 30\ud654 (480p)","ortitle":"","comment":"0","hd":"","mobile":"1","size":"259M","realsize":"271642374","point":"50","catecode":"BD_DM_03","catename":"\uc911\uad6d\ub4dc\ub77c\ub9c8","nickname":"l\ube14\ub8e8\uc5d4\uc824l","passnick":"f4b1k2b1t1b1q2b1v1b1o0b162b1i0b132b1f4b1","chkcopy":"N","chkcopy_set":"N","filecrack":"","discount":""},{"idx":"23044552","req":"0","adult":"N","ad_copy":"","color":"","bold":"","title":"[SD] \uc0ac\uc870\uc601\uc6c5\uc804 2008 29\ud654 (480p)","ortitle":"","comment":"0","hd":"","mobile":"1","size":"257M","realsize":"268980752","point":"50","catecode":"BD_DM_03","catename":"\uc911\uad6d\ub4dc\ub77c\ub9c8","nickname":"l\ube14\ub8e8\uc5d4\uc824l","passnick":"f4b1k2b1t1b1q2b1v1b1o0b162b1i0b132b1f4b1","chkcopy":"N","chkcopy_set":"N","filecrack":"","discount":""},{"idx":"23044551","req":"0","adult":"N","ad_copy":"","color":"","bold":"","title":"[SD] \uc0ac\uc870\uc601\uc6c5\uc804 2008 28\ud654 (480p)","ortitle":"","comment":"0","hd":"","mobile":"1","size":"262M","realsize":"274223026","point":"50","catecode":"BD_DM_03","catename":"\uc911\uad6d\ub4dc\ub77c\ub9c8","nickname":"l\ube14\ub8e8\uc5d4\uc824l","passnick":"f4b1k2b1t1b1q2b1v1b1o0b162b1i0b132b1f4b1","chkcopy":"N","chkcopy_set":"N","filecrack":"","discount":""},{"idx":"23044550","req":"0","adult":"N","ad_copy":"","color":"","bold":"","title":"[SD] \uc0ac\uc870\uc601\uc6c5\uc804 2008 27\ud654 (480p)","ortitle":"","comment":"0","hd":"","mobile":"1","size":"256M","realsize":"268219006","point":"50","catecode":"BD_DM_03","catename":"\uc911\uad6d\ub4dc\ub77c\ub9c8","nickname":"l\ube14\ub8e8\uc5d4\uc824l","passnick":"f4b1k2b1t1b1q2b1v1b1o0b162b1i0b132b1f4b1","chkcopy":"N","chkcopy_set":"N","filecrack":"","discount":""},{"idx":"23044614","req":"0","adult":"N","ad_copy":"","color":"","bold":"","title":"[\uc911\ub4dc] \uc5fc\uace8 40\ud654 mp4","ortitle":"","comment":"0","hd":"Y","mobile":"1","size":"476M","realsize":"499211831","point":"50","catecode":"BD_DM_03","catename":"\uc911\uad6d\ub4dc\ub77c\ub9c8","nickname":"dfca11","passnick":"86b186b1q4b1o4b1l4b1n4b1","chkcopy":"N","chkcopy_set":"N","filecrack":"","discount":""},{"idx":"23044549","req":"0","adult":"N","ad_copy":"","color":"","bold":"","title":"[SD] \uc0ac\uc870\uc601\uc6c5\uc804 2008 26\ud654 (480p)","ortitle":"","comment":"0","hd":"","mobile":"1","size":"254M","realsize":"266408566","point":"50","catecode":"BD_DM_03","catename":"\uc911\uad6d\ub4dc\ub77c\ub9c8","nickname":"l\ube14\ub8e8\uc5d4\uc824l","passnick":"f4b1k2b1t1b1q2b1v1b1o0b162b1i0b132b1f4b1","chkcopy":"N","chkcopy_set":"N","filecrack":"","discount":""},{"idx":"23044547","req":"0","adult":"N","ad_copy":"","color":"","bold":"","title":"[SD] \uc0ac\uc870\uc601\uc6c5\uc804 2008 25\ud654 (480p)","ortitle":"","comment":"0","hd":"","mobile":"1","size":"257M","realsize":"269041101","point":"50","catecode":"BD_DM_03","catename":"\uc911\uad6d\ub4dc\ub77c\ub9c8","nickname":"l\ube14\ub8e8\uc5d4\uc824l","passnick":"f4b1k2b1t1b1q2b1v1b1o0b162b1i0b132b1f4b1","chkcopy":"N","chkcopy_set":"N","filecrack":"","discount":""},{"idx":"23044546","req":"0","adult":"N","ad_copy":"","color":"","bold":"","title":"[SD] \uc0ac\uc870\uc601\uc6c5\uc804 2008 24\ud654 (480p)","ortitle":"","comment":"0","hd":"","mobile":"1","size":"262M","realsize":"274959755","point":"50","catecode":"BD_DM_03","catename":"\uc911\uad6d\ub4dc\ub77c\ub9c8","nickname":"l\ube14\ub8e8\uc5d4\uc824l","passnick":"f4b1k2b1t1b1q2b1v1b1o0b162b1i0b132b1f4b1","chkcopy":"N","chkcopy_set":"N","filecrack":"","discount":""},{"idx":"23044544","req":"0","adult":"N","ad_copy":"","color":"","bold":"","title":"[SD] \uc0ac\uc870\uc601\uc6c5\uc804 2008 23\ud654 (480p)","ortitle":"","comment":"0","hd":"","mobile":"1","size":"266M","realsize":"278871986","point":"50","catecode":"BD_DM_03","catename":"\uc911\uad6d\ub4dc\ub77c\ub9c8","nickname":"l\ube14\ub8e8\uc5d4\uc824l","passnick":"f4b1k2b1t1b1q2b1v1b1o0b162b1i0b132b1f4b1","chkcopy":"N","chkcopy_set":"N","filecrack":"","discount":""},{"idx":"23044604","req":"0","adult":"N","ad_copy":"","color":"","bold":"","title":"[\uc911\ub4dc] \uc5fc\uace8 33\ud654 mp4","ortitle":"","comment":"0","hd":"Y","mobile":"1","size":"432M","realsize":"452467264","point":"1500","catecode":"BD_DM_03","catename":"\uc911\uad6d\ub4dc\ub77c\ub9c8","nickname":"dfca11","passnick":"86b186b1q4b1o4b1l4b1n4b1","chkcopy":"Y","chkcopy_set":"Y","filecrack":"","discount":""},{"idx":"23044541","req":"0","adult":"N","ad_copy":"","color":"","bold":"","title":"[SD] \uc0ac\uc870\uc601\uc6c5\uc804 2008 22\ud654 (480p)","ortitle":"","comment":"0","hd":"","mobile":"1","size":"264M","realsize":"276517673","point":"50","catecode":"BD_DM_03","catename":"\uc911\uad6d\ub4dc\ub77c\ub9c8","nickname":"l\ube14\ub8e8\uc5d4\uc824l","passnick":"f4b1k2b1t1b1q2b1v1b1o0b162b1i0b132b1f4b1","chkcopy":"N","chkcopy_set":"N","filecrack":"","discount":""}],"pageing":{"html":"


JSON.UnescapeJavascript()

 
#2
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")
#3
Thank you for your reply.
I've got a lot of help with your answer.


Forum Jump:


Users browsing this thread: 1 Guest(s)