Trying to concatenate a specific row from multiple XML files into a single file

50 views Asked by At

I am trying to create a single file that contains a specific row from a little over 1000 XML (GPX) files. More specifically, I am trying to return row 13, which is the first row that contains GPS locations from multiple files for race events. The XSD for the file is described here: http://www.topografix.com/GPX/1/1/gpx.xsd.

I tried importing the files in Excel but that proved to be a quite manual process.

Here's an excerpt from one of the files:

<?xml version="1.0" encoding="UTF-8"?>
<gpx
  version="1.1"
  creator="Runkeeper - http://www.runkeeper.com"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns="http://www.topografix.com/GPX/1/1"
  xsi:schemaLocation="http://www.topografix.com/GPX/1/1 http://www.topografix.com/GPX/1/1/gpx.xsd"
  xmlns:gpxtpx="http://www.garmin.com/xmlschemas/TrackPointExtension/v1">
<trk>
  <name><![CDATA[Running 6/5/18 4:17 pm]]></name>
  <time>2018-06-05T20:17:57Z</time>
<trkseg>
<trkpt lat="45.424648000" lon="-75.716201000"><ele>57.0</ele><time>2018-06-05T20:17:57Z</time></trkpt>

I am trying to return the contents of the first <trkpt></trkpt> element.

0

There are 0 answers