UNIX for Dummies Questions & Answers

Well I have read several threads on the subject ... but being a newbie like me makes it hard to understand ...

What I need is the following:

Input data:

------- snip ---------

<FavouriteLocations> <FavouriteLocations class="FavouriteList"><Item
class="Favourite"><DisplayName>Hem</DisplayName><Behaviour>0</Behaviour><LastUsed>2</LastUsed><StickyOrder>0</StickyOrder><Object
class="Location"><name>41837</name><name2></name2><lat>5772743</lat><long>1188701</long><entryName>A Street</entryName><entryLat>5772743</entryLat><entryLong>1188701</entryLong><entryHeading>-1</entryHeading><entrySideOfLine>0</entrySideOfLine><entryHouseNo>5</entryHouseNo><entryPostcode>41837</entryPostcode><entryResolved>1</entryResolved><entryValid>1</entryValid><entryMaxRoad>0</entryMaxRoad><entryHalfSize>0</entryHalfSize><source>5</source><resultType>6</resultType><photo></photo><typeName></typeName><phoneNum></phoneNum><description></description><type>road</type></Object></Item>

------ snip-------

The file has several of these items in them ...

And what I need to extract is the <lat>, <long> and <entryName> data ...on one row.

If possible I would prefer this in awk ... since I have just started to understand the basics of this ...

Hope somebody can help me out !!!!

Thanks in advance !

/misak

Hi
This isn't elegant, but I hope this will be helpful.
I've copied the fragment to a file named test_file. (Since I don't know a thing about XML, I guessed that lat is the field between the tags <lat> and </lat> and so on)
Then I did the following

cat test_file|while read line
do
lat=$(echo $line|nawk -F"<lat>" '{print $2}'|nawk -F"</lat>" '{print $1}')
long=$(echo $line|nawk -F"<long>" '{print $2}'|nawk -F"</long>" '{print $1}')
entryName=$(echo $line|nawk -F"<entryName>" '{print $2}'|nawk -F"</entryName>" '{print $1}')
echo "$lat $long $entryName"
done

The result is the following:





5772743 1188701 A Street



As you can see, there are blank lines, but I guess this isn't a real problem.
In any case, I'm sure that is possible to solve it in a elegant way.
Regards.

Thanks for the reply Fran

The problem is that if there are more items in the file ... it only grabs the first one ... maybe because there is no NewLine ...

I will post a larger snip of the file ....

---- snip ----

<FavouriteLocations> <FavouriteLocations class="FavouriteList"><Item
class="Favourite"><DisplayName>Hem</DisplayName><Behaviour>0</Behaviour><LastUsed>2</LastUsed><StickyOrder>0</StickyOrder><Object
class="Location"><name>41837</name><name2></name2><lat>5772743</lat><long>1188701</long><entryName>Dimvädersgatan</entryName><entryLat>5772743</entryLat><entryLong>1188701</entryLong><entryHeading>-1</entryHeading><entrySideOfLine>0</entrySideOfLine><entryHouseNo>5</entryHouseNo><entryPostcode>41837</entryPostcode><entryResolved>1</entryResolved><entryValid>1</entryValid><entryMaxRoad>0</entryMaxRoad><entryHalfSize>0</entryHalfSize><source>5</source><resultType>6</resultType><photo></photo><typeName></typeName><phoneNum></phoneNum><description></description><type>road</type></Object></Item><Item
class="Favourite"><DisplayName>Färdvägsplanerare</DisplayName><Behaviour>0</Behaviour><LastUsed>3</LastUsed><StickyOrder>1</StickyOrder></Item><Item
class="Favourite"><DisplayName>Dimvädersgatan 5</DisplayName><Behaviour>1</Behaviour><LastUsed>1</LastUsed><StickyOrder>-1</StickyOrder><Object
class="Location"><name>41837</name><name2></name2><lat>5772743</lat><long>1188701</long><entryName>Dimvädersgatan</entryName><entryLat>5772743</entryLat><entryLong>1188701</entryLong><entryHeading>-1</entryHeading><entrySideOfLine>0</entrySideOfLine><entryHouseNo>5</entryHouseNo><entryPostcode>41837</entryPostcode><entryResolved>1</entryResolved><entryValid>1</entryValid><entryMaxRoad>0</entryMaxRoad><entryHalfSize>0</entryHalfSize><source>5</source><resultType>6</resultType><photo></photo><typeName></typeName><phoneNum></phoneNum><description></description><type>road</type></Object></Item><Item
class="Favourite"><DisplayName>Uttagsautomat</DisplayName><Behaviour>1</Behaviour><LastUsed>0</LastUsed><StickyOrder>-1</StickyOrder><Object
class="Location"><name>Uttagsautomat</name><name2></name2><lat>5772164</lat><long>1193476</long><entryName>Wieselgrensplatsen</entryName><entryLat>5772163</entryLat><entryLong>1193475</entryLong><entryHeading>67</entryHeading><entrySideOfLine>-1</entrySideOfLine><entryHouseNo>0</entryHouseNo><entryPostcode></entryPostcode><entryResolved>1</entryResolved><entryValid>1</entryValid><entryMaxRoad>0</entryMaxRoad><entryHalfSize>0</entryHalfSize><source>5</source><resultType>11</resultType><photo></photo><typeName>Bankomat</typeName><phoneNum></phoneNum><description></description><type>poi</type></Object></Item></FavouriteLocations></FavouriteLocations>

------- snip -------


Hope it helps a bit ... and thanks for all the help here !

/misak

So, are you saying that the text is an uniq line with several concurrences of <lat>?

yeah it seems that way ... huuu

/misak

While you can use awk and other command line utilities to parse your file and extract the data you require, a better way is to use tools which are designed to work with XML documents.

For the purposes of this example, I have simplified the structure of your document down to the following elements (demo.xml):

Code:

<FavouriteLocations>
   <FavouriteLocations class="FavouriteList">
       <Item class="Favourite">
          <Object class="Location">
              <lat>LAT1</lat>
              <long>LONG1</long>
              <entryName>NAME1</entryName>
          </Object>
       </Item>
       <Item class="Favourite">
          <Object class="Location">
              <lat>LAT2</lat>
              <long>LONG2</long>
              <entryName>NAME2</entryName>
          </Object>
       </Item>
       <Item class="Favourite">
          <Object class="Location">
              <lat>LAT3</lat>
              <long>LONG3</long>
              <entryName>NAME3</entryName>
          </Object>
       </Item>
    </FavouriteLocations>
</FavouriteLocations>

The best tool to extract the data you want from this XML document is a stylesheet transformation processor such as xsltproc or saxon. Here is a simple stylesheet (demo.xsl) which extracts values of the lat, long and entryName elements.

Code:

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:output method="text"/>

<xsl:template match="/">
   <xsl:apply-templates select="//Object" />
</xsl:template>

<xsl:template match="//Object">
    <xsl:value-of select="./lat"/>
    <xsl:text>   </xsl:text>
    <xsl:value-of select="./long"/>
    <xsl:text>   </xsl:text>
    <xsl:value-of select="./entryName"/>
    <xsl:text>
</xsl:text>
</xsl:template>

</xsl:stylesheet>

Here is the output from transforming the document using xsltrpoc.

Code:

$ xsltproc demo.xsl demo.xml
LAT1   LONG1   NAME1
LAT2   LONG2   NAME2
LAT3   LONG3   NAME3
$

Problem solved ...
Thanks a million people ... for the responses
I went with the xsltproc solution ... works fine

Take care !

/misak