Completed

XML data extraction to CSV

I have several 100 .xml files of some size.

I need a script that can find data between 2 tags and write that data to a new file.

I would like to be able to run this in a folder full of xml files and have the script return 1 file per xml

with the tag as the header record and the data listed below.

here is a sample of a record from one of the xml files.

A complete xml is attached.

<App action="A" id="1">

<BaseVehicle id="1"/>

<EngineBase id="13"/>

<Qty>1</Qty>

<PartType id="2172"/>

<Part>OR2451</Part>

<DisplayOrder>1</DisplayOrder>

I would like the PartTypeID and Part extracted..

Some things of note.. the files will all have these 2 tags inside the App record however they may not be above one another in each file as to say other tags maybe in between. I do have notepad++ if someone could write a macro? to do this or I am flexible for other solutions.

Skills: XML

See more: xml data extraction, xml data extraction wikipedia, python script data extraction csv, convert xml to csv excel, xml to csv converter download, convert large xml to csv, convert xml to csv powershell, xml to csv c#, convert xml to excel online, xml to csv java, xml to csv linux, web data extraction csv, csv data extraction, data extraction csv files database, net web data extraction xml, xml data extraction company, xml data extraction java, virtuemart csv xml data feed, convert onix xml data csv file, excel 2007 macro convert csv xml data import

About the Employer:
( 120 reviews ) BORING, United States

Project ID: #19283886

Awarded to:

julienmoutier

Hello ! I'm experienced in this kind of script development and available for your project; I can start now and get it done in an hour or two. Feel free to contact me to discuss it in details !

$66 USD in 1 day
(2 Reviews)
3.0

3 freelancers are bidding on average $79 for this job

msteidley

I have extensive experience with python and xml files. I could provide a python script or gui application which can extract that data for you.

$120 USD in 5 days
(1 Review)
1.6
Mokshith30

hi I am vba developer experienced in web scraping &vba macros I will finish this task in a day only pls share the details thanks

$50 USD in 1 day
(0 Reviews)
0.0