Geek asks and answers

How to extract data from xml file using notepad ++?

I have an xml response with a structure (e.g. group> subgroups> child records).

I want to extract a list of all childRecord.name as separate data. I was hoping I could do something quickly in notepad ++, and then paste the results into excel.

I'm not sure how to start writing a macro maybe in this case that will do it for me.

<group>

  <subgroup>

    <childrecord name="abc">zzz</childrecord>

  </subgroup>

</group>
+5
source share
2 answers

Open the XML file using MS Excel directly.

Update

From support.office.com :

Import XML data file as XML table

  • Click Developer> Import.

    "", . "" .

  • " XML" XML (.xml), , "".

    XML , Excel XML.

  • " " :

    . XML , XML XML .

    . XML , XML , A1. XML XML Source.

  • XML , Excel > XML.

  • XML (, , ), "", XML. , , .

XML LibreOffice Calc:

  • Data > XML Source...
  • ( )
  • node
  • Mapped cell, A1
  • Import.
+14

:

  • XML Notepad ++
  • Use this menu: TextFX → TextFX Convert → Strip HTLM tabs / nontabs table tags
+1
source

More articles:


All Articles