How to parse json with nested data?

Segment of the json feed:

Please Login or Register  to view this content.

The following code will parse the "last name" field:

Please Login or Register  to view this content.

But can't figure out how to parse the "round1" total score which is nested in a second set of {} ?

Any pointers would be much appreciated!

Json text format can also be directly parsed with VBA text functions or via a JScript evaluation like in post #9 of this thread …

According to your segment :

PHP Code: 

    With CreateObject("ScriptControl")
             .Language = "JScript"
        With .Eval("(" & CF & ")")
            Debug.Print "last_name    :  "; .last_name; vbLf; "round1.total : "; CallByName(.round1, "total", VbGet)
        End With
    End With 


And the classic Split text VBA function for starters :

PHP Code: 

    Dim S$(), L&, T$
        S = Split(CF, """id"" : """)
    For L = 1 To UBound(S)
        T = Split(S(L), """last_name""")(1)
        Debug.Print "Last Name    : "; Split(T, """")(1); vbLf; _
                    "Round1 Total : "; Split(Split(Split(T, """round1""")(1), """total"" : ")(1), "}")(0)
    Next 


► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

As a side note; you can not use the "MSScriptControl.ScriptControl" object directly in 64 Bit Excel.