SASnewbie
asked on
Parse XML file to visually display tree and details
Hi,
In need of a tool to parse an XML file to be able to see the parent/child in tree diagram and all tool configuration details.
Thanks,
AlteryxDocument-yxmdVer.xml
In need of a tool to parse an XML file to be able to see the parent/child in tree diagram and all tool configuration details.
Thanks,
AlteryxDocument-yxmdVer.xml
In addition to XML Notepad, I also use XMLPad.
http://wmhelp.com/
http://wmhelp.com/
ASKER
Thank you for the suggestions. These can come in handy at some point. but what I am looking for is a tool that will graphically display the nodes, parent/children and details.
For example:
<ChildNodes>
<Node ToolID="4660">
<GuiSettings Plugin="AlteryxBasePlugins Gui.Filter .Filter">
<Position x="1002" y="7134" />
</GuiSettings>
<Properties>
<Configuration>
<Expression><![CDATA[ ([Channel] IN ("Indirect")
AND
[Product Code] IN ("350", "354", "378", "380", "381", "383", "383", "384", "385", "386", "387", "388", "394", "395", "396", "397", "398", "885", "890", "403","405"))
AND
([Sales Channel] NOT IN ("Direct","DIRECT","US Customer Center","US Customer Centers","Northern Latin America","Southern Latin America","Latin America AS", "Latin America TFM")
AND
[Product Type Code]!="80")
AND
[Branch] NOT IN ("GOVERNMENT","ITS Internal Product Request", "Warranty & Goodwill Order Processing", "Direct Sales & Service","ZEKS")
AND [Product Family] not in ("Air", "Fluid")
AND FINDSTRING([CCN],"GENERAL MISC COMP")=-1
]]></Expression>
<Mode>Custom</Mode>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText><![ CDATA[ ([Channel] IN ("Indirect")
AND
[Product Code] IN ("350", "35...]]></DefaultAnnotati onText>
</Node>
For example:
<ChildNodes>
<Node ToolID="4660">
<GuiSettings Plugin="AlteryxBasePlugins
<Position x="1002" y="7134" />
</GuiSettings>
<Properties>
<Configuration>
<Expression><![CDATA[ ([Channel] IN ("Indirect")
AND
[Product Code] IN ("350", "354", "378", "380", "381", "383", "383", "384", "385", "386", "387", "388", "394", "395", "396", "397", "398", "885", "890", "403","405"))
AND
([Sales Channel] NOT IN ("Direct","DIRECT","US Customer Center","US Customer Centers","Northern Latin America","Southern Latin America","Latin America AS", "Latin America TFM")
AND
[Product Type Code]!="80")
AND
[Branch] NOT IN ("GOVERNMENT","ITS Internal Product Request", "Warranty & Goodwill Order Processing", "Direct Sales & Service","ZEKS")
AND [Product Family] not in ("Air", "Fluid")
AND FINDSTRING([CCN],"GENERAL MISC COMP")=-1
]]></Expression>
<Mode>Custom</Mode>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText><![
AND
[Product Code] IN ("350", "35...]]></DefaultAnnotati
</Node>
I think what you're looking for is a tool with xquery support. There are both downloadable and online tools that might work, but I have no experience with any of them. Have you looked at any of these tools?
ASKER
Attached is an example of what I need:
Capture.PNG
Capture.PNG
ASKER
Hi aikimark,
Will search for xquery support. I didn't know what to look for, but will do so now.
Thanks!
Will search for xquery support. I didn't know what to look for, but will do so now.
Thanks!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Pravin,,
Will do!
Thanks!
Will do!
Thanks!
Thanks,
Glad to be of some help
Glad to be of some help
You can also open it in most web browsers and it will display nicely as well.