VBScript and Xpath excluding duplicates [closed]
- by Malachi
I am trying to pull names from an XML Document using a vbscript.
XML Document structure
<Aliases>
<Alias PartyType="DF" CaseID="000000" NameType=""> Name Name</Alias>
<Alias PartyType="DF" CaseID="000000" NameType=""> Name Name</Alias>
<Alias PartyType="DF" CaseID="000000" NameType=""> Name Name</Alias>
...
</Aliases>
the XML File might have 100 rows with the same name coming from several different CaseID's because for this part of my vbscript I am trying to pull all the different Names from all cases, but here is the issue, I don't want to return duplicates.
is there a way to do this with an xPath Expression or should I try to do this with VBScript?
EDIT
I am pretty sure that I am going to have to do this with VBScript.
Would it be Faster and more efficient to solve this issue in VBScript, xPath, or in populating the XML I am retrieving information from ( this might prove more difficult than the other two options )
I am also asking a Similar question on stackoverflow