How to count number of element in json array

Question

I have a simple JSON array like this:

["123", "124", "321"]

The expected result should be 3. How can I count the number of elements without using regular expressions and always working with a JSON object?

I tried using the following code:

Dim jsonStr, jsonArray, elementCount
jsonStr = "[""123"", ""124"", ""321""]"
Set jsonScriptControl = CreateObject("ScriptControl")
jsonScriptControl.Language = "JScript"
Set jsonArray = jsonScriptControl.Eval("(" + jsonStr + ")")
elementCount = jsonArray.Length
MsgBox "Number of elements: " & elementCount

However, I encountered an error message:

Microsoft VBScript runtime error: An ActiveX component cannot create an object: 'ScriptControl'.

This was a few days ago... How to access JSON object returned from createObject("htmlfile") in VBS file — user692942
– user692942, Commented Jul 10, 2023 at 13:23
Does this answer your question? Decode/Encode JSON with VBScript — user692942
– user692942, Commented Jul 10, 2023 at 13:27
Does this answer your question? How to access JSON object returned from createObject("htmlfile") in VBS file — LesFerch
– LesFerch, Commented Jul 10, 2023 at 13:33
If you are sure of json being an arry you can use elementCount=ubound(split(jsonstr,","))+1 — Antoni Gual Via
– Antoni Gual Via, Commented Jul 12, 2023 at 6:44
Follow-up would be appreciated. Did you resolve the issue some other way? — LesFerch
– LesFerch, Commented Jul 17, 2023 at 13:46

LesFerch · Accepted Answer · 2023-07-12 15:14:07Z

0

ScriptControl is a 32 bit object. Therefore, your script must be run using a 32 bit scripting host:

c:\windows\syswow64\wscript.exe My32bitScript.vbs

Alternatively, for 64bit, use htmlfile:

jsonStr = "[""123"", ""124"", ""321""]"
Set html = wscript.CreateObject("htmlfile")
Set window = html.parentWindow
window.execScript "var json = " & jsonStr, "JScript"
Set jsonArray = window.json 
elementCount = jsonArray.Length
MsgBox "Number of elements: " & elementCount

answered Jul 12, 2023 at 15:14

LesFerch

1,9972 gold badges8 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to count number of element in json array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related