skilled1
11-21-2008, 03:38 PM
So here is the thing.
I am currently using dreamweaver to cheat.
esentially i am trying to convert a ton of google placemarks from a kml file to a plain text file for import into excel and into a spread sheet.
kml > xls conversion
What I have done is open the kml file in dreamweaver and replaced alot of the extra xml code with blanks, however I am looking to replace a large block of code with a return carrige.
what i need to replace is the following
<LookAt>
<longitude>17.87895484388781</longitude>
<latitude>59.38922383368543</latitude>
<altitude>0</altitude>
<range>1663.929133781522</range>
<tilt>4.827137888079447e-11</tilt>
<heading>7.873743945997011e-15</heading>
</LookAt>
<styleUrl>#msn_blue-pushpin_copy24</styleUrl>
<Point>
<coordinates>17.87895484388781,59.38922383368543,0</coordinates>
</Point>
</Placemark>
so the statement i am looking for is
<LookAt> and the wildcard </Placemark> and replace it with a return carrige. Does anyone know what kind of statement i need to be able to achieve this?
I am currently using dreamweaver to cheat.
esentially i am trying to convert a ton of google placemarks from a kml file to a plain text file for import into excel and into a spread sheet.
kml > xls conversion
What I have done is open the kml file in dreamweaver and replaced alot of the extra xml code with blanks, however I am looking to replace a large block of code with a return carrige.
what i need to replace is the following
<LookAt>
<longitude>17.87895484388781</longitude>
<latitude>59.38922383368543</latitude>
<altitude>0</altitude>
<range>1663.929133781522</range>
<tilt>4.827137888079447e-11</tilt>
<heading>7.873743945997011e-15</heading>
</LookAt>
<styleUrl>#msn_blue-pushpin_copy24</styleUrl>
<Point>
<coordinates>17.87895484388781,59.38922383368543,0</coordinates>
</Point>
</Placemark>
so the statement i am looking for is
<LookAt> and the wildcard </Placemark> and replace it with a return carrige. Does anyone know what kind of statement i need to be able to achieve this?