Get TEXT data from XML files

[wayne_taylor]

Hi All

I'm trying to access TEXT data in an XML file. I can get the Attributes fine, but not the text!  

The XML file is in format below and I can access the ActionRow data (ID/BID/XYX) ok by expanding the table, but I also need the MAINID value (2888 in this example), but can't figure out how to get it!

Any help appreciated.

Wayne

<XMLFEED>

  <MAINID>2888

  <Data>

      <ActionRow ID="123" BID="321" XYX="999"/>

      <ActionRow ID="124" BID="333" XYX="888"/>

  </Data>

  </MAINID>

</XMLFEED>

[Zubair_Muhammad]

@wayne_taylor 

Try this custom Column

Change the file name and address in red font below

=Text.BeforeDelimiter(
Xml.Document(File.Contents("C:\Users\hp\Desktop\File.xml"))[Value]{0}[Value]{0},
" ")