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