String content

[RobertLees]

Hi

This is an easy one, and I think I will be embarased when (if) I get the answer.

I've got a string of 3 fields, delimited by colons. How do I get the posibion of these colons so I can extract the fields with a MID ?

Thanks
Robert

[neicedover1982]

Why dont you just use a Split() statement and split the words into an array?

Dim yArray
sentence = one:two:three
yArray = Split(sentence,":")
yArray(0)= one
yArray(1)= two
yArray(2)= three

[MartinLiss]

A more generalized solution would be

Dim strParts() As String
Dim lngIndex As Long
 
strParts = Split(YOUR_STRING, ":")
 
For lngIndex = 0 To UBound(strParts)
    Debug.Print strParts(lngIndex)
Next

[neicedover1982]

I just wrote the yarray(0) etc to show what the array would be filled like. thats good code MartinLiss. I might have to change how I loopp through my arrays, lol.

[RobertLees]

Thanks guys.

After I posted my question, I remembered the Instr. I didn't know about Split. But I do now.

Thanks
Robert

[neicedover1982]

If your question is answered, make your thread as resolved.

[MartinLiss]

And you can do that by pulling down the Thread Tools menu and clicking the Mark Thread Resolved button.