Forum Discussion

wayne_taylor's avatar
wayne_taylor
Regular Visitor
7 years ago

Get TEXT data from XML files

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>

 

 

Need Help

1 Reply

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    7 years ago

    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},
" ")