Get specific XML Tag based on it's descendant value

2022-08-01.xml (3.1 KB)
From this example XML I want to get Value of the Tag “Mid” if it’s sibling Tag “Code” is eg. USD. I managed to get all Rate and it’s descendants value but can’t get only the specific Mid value I want.

one of several options:

xDoc.Root.Descendants("Rate").where(Function (x) x.element("Code").value.equals("USD")).First().Element("Mid").Value

thank you for the answer.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.