There are multiple occurances of the PLUS_BORROWER data. For each occurence of PLUS_BORROWER, I want to save the CREDIT_SCORE and DAYTIME_PHONE_NBR when the Type= And SOCIAL_SECURITY_NBR are certain values.
Then I want to execute a loop and extract the Credit_Score and Daytime_Phone_Nbrs.
<PLUS_BORROWER Type="Primary">
<SOCIAL_SECURITY_NBR>123459999</SOCIAL_SECURITY_NBR>
<CREDIT_SCORE ModelName="Emperica">793</CREDIT_SCORE>
<DAYTIME_PHONE_NBR>4077889999</DAYTIME_PHONE_NBR>
<DAYTIME_PHONE_EXT>101</DAYTIME_PHONE_EXT>
</PLUS_BORROWER>
I have the following code that will pull off the first PLUS_BORROWER if the Type='Primary', but I am having trouble expanding it.
oExtraData.Load(myXMLFile)
'only select nod with type attribute equal primary
Dim oNode As Xml.XmlNode = oExtraData.SelectSingleNode("//PLUS_BORROWER[@Type='Primary']")
'get credit score node
Dim scoreNode As Xml.XmlNode = oNode.SelectSingleNode("CREDIT_SCORE")
MsgBox("I have the Primary")
MsgBox("Credit score is " & scoreNode.InnerText)