[RESOLVED] String parsing

Well, I'm only a few months into VB so I suck with parsing stuff. Used to PHP's preg_match(). :P

Anyway I have loaded the following string from a file:

Code:

---

config
{
    Key1 "Value1";
    Key2 "Value2";
    Key3
    {
        "Value3";
        "Value4";
    };
};

---

And I want to load it into some soft of 2d array.
arr("Key1") = "Value1"
arr("Key2") = "Value2"
arr("Key3")(0) = "Value3"
arr("Key3")(1) = "Value4"
Ideas? Other then looping though string char at a time. lol

Can you change the format of the file or is that fixed?

This will parse out the values for you. If there will be more than one instance of a sub-key, you can split the string on "{" first to get a grouping of the subkeys.

VB Code:

Dim sFirst() As String, sSecond() As String, iCount As Integer, sTemp As String
 
sFirst = Split(sString, Chr$(34) & ";")     'where sString is your input.
 
For iCount = 0 To UBound(sFirst) - 1
    sSecond = Split(sFirst(iCount), Chr$(34))
    sTemp = sSecond(UBound(sSecond))
    Debug.Print sTemp
Next iCount

Pino, yes.

Comintern, so im stuck playing with the string functions eh

Quote:

---

Originally Posted by frozen

Pino, yes.

Comintern, so im stuck playing with the string functions eh

---

Well, you could use regular expression, but string functions are pretty easy on this one. Check out this link if you want to get started on the RegExp object. I've just personally never used it.

That's actually quite complex, to do a proper parse of that would require some recursion I think. Either that or I'm just VERY rusty with VB.

Bump.

Quote:

---

Originally Posted by frozen

Bump.

---

I Googled RegExp object model and came up with this. It should get you started. You can also check this link. The Like operator might also be of use.