Get data from "xml" file

[Tribor]

Hello,

I have some *.sym file, what is in xml format.
Next to end of the file there is QuotationInfo block, I need to get all symbol name value from the <Info num="4" name="Contained Symbols"

<QuotationInfo>
<Info num="0" name="Number of Loops" value="2"/>
<Info num="3" name="Number of Contained Symbols" value="2"/>
<Info num="4" name="Contained Symbols">
<Symbol name="U-6088-DF-20-3-POS40-D" count="1"/>
<Symbol name="U-6088-DF-20-3-POS70-D" count="1"/>
</Info>
<Info num="5" name="Number of Tools">

Anybody can show how can I get these values?
I attached an exaple symbol file the this post.


Best Reagrds,

Tibi

[dbasnett]

Assuming that the file is an XML file, this should help.

        Dim xe As XElement

        'to load from file
        '  xe=XElement.Load("your path here")

        'to test
        xe = <root>
                 <QuotationInfo>
                     <Info num="0" name="Number of Loops" value="2"/>
                     <Info num="3" name="Number of Contained Symbols" value="2"/>
                     <Info num="4" name="Contained Symbols">
                         <Symbol name="U-6088-DF-20-3-POS40-D" count="1"/>
                         <Symbol name="U-6088-DF-20-3-POS70-D" count="1"/>
                     </Info>
                     <Info num="5" name="Number of Tools"/>
                 </QuotationInfo>
             </root>

        Dim ie As IEnumerable(Of XElement)

        ie = From el In xe...<QuotationInfo>.Elements
             Where el.Name.LocalName = "Info" AndAlso el.@num = "4" AndAlso el.@name = "Contained Symbols"
             From sel In el.Elements Select sel

        For Each el As XElement In ie
            Debug.WriteLine("{0}  {1}", el.Name.LocalName, el.@name)
        Next

How well it works depends on the actual file format. Attaching a sample file would help.