Hi Guys! I want to parse it with VB but if there is an easier way, I am open to suggestions.
I have:
Code:
<search value="5/12/2014">
<departure value="US">
<resort value="Barbados">
<date value="10/25/2014">
<price value="1200" />
<seat value="9" />
</date>
</resort>
</departure>
</search>
<search value="5/12/2014">
<departure value="US">
<resort value="Barbados">
<date value="11/1/2014">
<price value="1000" />
<seat value="9" />
</date>
</resort>
</departure>
</search>
<search value="5/12/2014">
<departure value="Brazil">
<resort value="Barbados">
<date value="10/25/2014">
<price value="1100" />
<seat value="9" />
</date>
</resort>
</departure>
</search>
<search value="5/12/2014">
<departure value="Brazil">
<resort value="Barbados">
<date value="11/1/2014">
<price value="1000" />
<seat value="9" />
</date>
</resort>
</departure>
</search>
<search value="5/13/2014">
<departure value="US">
<resort value="Barbados">
<date value="10/4/2014">
<price value="1100" />
<seat value="9" />
</date>
</resort>
</departure>
</search>
<search value="5/13/2014">
<departure value="US">
<resort value="Barbados">
<date value="10/11/2014">
<price value="1100" />
<seat value="6" />
</date>
</resort>
</departure>
</search>
I want to merge all nodes if have the same value until it has a different child value like this:
Code:
<search value="5/12/2014">
<departure value="US">
<resort value="Barbados">
<date value="10/25/2014">
<price value="1200" />
<seat value="9" />
</date>
<date value="11/1/2014">
<price value="1000" />
<seat value="9" />
</date>
</resort>
</departure>
<departure value="Brazil">
<resort value="Barbados">
<date value="10/25/2014">
<price value="1100" />
<seat value="9" />
</date>
<date value="11/1/2014">
<price value="1000" />
<seat value="9" />
</date>
</resort>
</departure>
</search>
<search value="5/13/2014">
<departure value="US">
<resort value="Barbados">
<date value="11/1/2014">
<price value="1000" />
<seat value="9" />
</date>
<date value="10/11/2014">
<price value="1100" />
<seat value="6" />
</date>
</resort>
</departure>
</search>
Thanks a lot!