i am looking to do something like this article
Basically, I have an xml file with a ton of sections, keys and CDATA sections.
I need to make a template in order to separate the section start into column A,
editable data to column B and the section end into column C.
excel does a horrible job at disallowing multiple delimiting characters (</) together.
My primary text editing tools are NP++ and xmlpad pro, but no such luck finding a plugin
or export function to segregate these xml sections.
Any help is appreciated.
Is there any way to tell powershell to move this </Asterisk> to column C, except for the text between <Begin> Asterisk </Begin> and <CDATA[[ Asterisk ]]>? this information would need to be moved to column B?
In fact xml editing is pretty easy in powershell...
You want to get data from xml and put it in Excel?
With select-xml (http://ss64.com/ps/select-xml.html) you can extract data using xpaths - to get info from cdtata sections ->
http://stackoverflow.com/questions/1274 … powershell
to write data into excel:
http://www.petri.co.il/export-to-excel- … rshell.htm
If you give more information about your xml structure will be easier to help