<div>
When the ctry values need to be sorted, then they seem important enough, the have their own element. E.g. 
<pre><code id="code-8262163">&lt;Ctrys&gt;
    &lt;Ctry&gt;FRA&lt;Ctry&gt;
    &lt;Ctry&gt;USA&lt;Ctry&gt;
    &lt;Ctry&gt;CAN&lt;Ctry&gt;
&lt;/Ctrys&gt;</code></pre>
</div>


When the ctry values need to be sorted, then they seem important enough, the have their own element. E.g.

<Ctrys>
    <Ctry>FRA<Ctry>
    <Ctry>USA<Ctry>
    <Ctry>CAN<Ctry>
</Ctrys>

<div>
Hi,<br />
<br />
Thanks for the code, will try it and get back to you.<br />
<br />
Victor
</div>


Hi,

Thanks for the code, will try it and get back to you.

Victor

<div>
Not a problem Victor, glad to help.
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
&nbsp;How would you load the xml file below and sort all the ctry data element?<br />
<br />
&nbsp;&lt;Root&gt;<br />
&nbsp;&lt;Table1&gt;<br />
&nbsp;&lt;Item&gt;1&lt;/Item&gt;<br />
&nbsp;&lt;Ctry&gt;BEL,USA,CAN&lt;Ctry&gt;<br />
&nbsp;&lt;/Table1&gt; <br />
&nbsp;&lt;Table1&gt;<br />
&nbsp;&lt;Item&gt;2&lt;/Item&gt;<br />
&nbsp;&lt;Ctry&gt;BEL,USA,CAN&lt;Ctry&gt;<br />
&nbsp;&lt;/Table1&gt; <br />
&nbsp;&lt;Table1&gt;<br />
&nbsp;&lt;Item&gt;3&lt;/Item&gt;<br />
&nbsp;&lt;Ctry&gt;FRA,USA,CAN&lt;Ctry&gt;<br />
&nbsp;&lt;/Table1&gt; <br />
&nbsp;&lt;Table1&gt;<br />
&nbsp;&lt;Item&gt;4&lt;/Item&gt;<br />
&nbsp;&lt;Ctry&gt;USA,CAN,FRA,NLD&lt;Ctry<wbr />&gt;<br />
&nbsp;&lt;/Table1&gt; <br />
&nbsp;&lt;/Root&gt;<br />
<br />
&nbsp;Thanks,<br />
<br />
&nbsp;Victor
</div>
</div>


Hi,

 How would you load the xml file below and sort all the ctry data element?

 <Root>
 <Table1>
 <Item>1</Item>
 <Ctry>BEL,USA,CAN<Ctry>
 </Table1> 
 <Table1>
 <Item>2</Item>
 <Ctry>BEL,USA,CAN<Ctry>
 </Table1> 
 <Table1>
 <Item>3</Item>
 <Ctry>FRA,USA,CAN<Ctry>
 </Table1> 
 <Table1>
 <Item>4</Item>
 <Ctry>USA,CAN,FRA,NLD<Ctry>
 </Table1> 
 </Root>

 Thanks,

 Victor

Help with sorting data element from xml file

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,