getting the length of a string 1

[camjon]

I would like to know if anyone knows how to get the length of a string that is in an xml file. Here is an example of what im trying to do

<trip>florida</trip>
<population>12346569</population>

I want to go in a get the length of the charcters that are in between the tags. If anyone knows how to do this, any help would be greatly appreciated. Thank you.

 

[PHV]

A starting point:

myStr = "<trip>florida</trip>"
MsgBox myStr & ":" & InStrRev(myStr, "<") - InStr(myStr, ">") - 1

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

How are ya camjon . . .

What you ask is complicated by the many [blue]relational terms[/blue] which can occur in XML. These terms take the following form and have to be allowed for:

[blue] [purple][b]<[/b][/purple][i]relational term here [/i][purple][b]/>[/b][/purple][/blue]

You'll have to expand on [blue]PHV's[/blue] post to meet your end.

Out of curiosity . . . [blue]whats the point of this?[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886