xslt concatenation

rouble

Hi All,

I am just picking up xslt and I was wondering if I could get some
pointers. I have an xml body that looks like this:

Expand|Select|Wrap|Line Numbers

 
   <location>

       <civic-address>

          <country>US</country>

          <A1>New York</A1>

          <A2>King's County</A2>

          <A3>New York</A3>

          <A4>Manhattan</A4>

          <A5>Morningside Heights</A5>

          <A6>Broadway</A6>

          <PRD>N</PRD>

          <POD>SW</POD>

          <STS>Street</STS>

          <HNO>123</HNO>

          <HNS>A</HNS>

          <LMK>Low Library</LMK>

          <LOC>Room 543</LOC>

          <FLR>5</FLR>

          <NAM>Joe's Barbershop</NAM>

          <PC>10027-0401</PC>

       </civic-address>

    </location>

   <location>

       <civic-address>

           ...

       </civic-address>

    </location>

   <location>

       <civic-address>

           ...

       </civic-address>

    </location>

I need to translate this (using xslt) to create a new element called
'street' that has the values of HNO HNS PRD A6 POD STS from one civic-
address. So the output should look like:

Expand|Select|Wrap|Line Numbers

 
   <location>

       <civic-address>

          <country>US</country>

          <A1>New York</A1>

          <A2>King's County</A2>

          <A3>New York</A3>

          <A4>Manhattan</A4>

          <A5>Morningside Heights</A5>

          <street> 123 A N Broadway SW Street </street>

          <LMK>Low Library</LMK>

          <LOC>Room 543</LOC>

          <FLR>5</FLR>

          <NAM>Joe's Barbershop</NAM>

          <PC>10027-0401</PC>

       </civic-address>

   </location>

   <location>

       <civic-address>

           ...

       </civic-address>

    </location>

   <location>

       <civic-address>

           ...

       </civic-address>

    </location>

If any of HNO HNS PRD A6 POD STS are missing, they should just be
ignored. If all of them are missing, then a 'street' element should
not be created.

I am looking for tips on creating an efficient xslt for this.

TIA,
rouble

Dormilich

Quote:

Originally Posted by rouble

I am looking for tips on creating an efficient xslt for this.

well, if you haven't done yet, I recommend reading a tutorial (www.w3schools.com/xslt). then you should try to put the creation of the <street> tag in a separate template. once that is running you need to put it in the copy-procedure (you'll find some copy templates in this forum).

if you're running into problems, just ask us

regards

jkmyoung

Quote:

If all of them are missing

Do you mean the elements themselves are missing, or there are empty elements? The solution can be quite different with each.

The solution with empty elements is much easier, and looks like:

Expand|Select|Wrap|Line Numbers

 
<xsl:template match="A6">

  <xsl:variable name="street">

    <xsl:value-of select="."/>

    <xsl:value-of select="following-sibling::PRD"/>

    <xsl:value-of select="following-sibling::POD"/>

    <xsl:value-of select="following-sibling::STS"/>

    <xsl:value-of select="following-sibling::HNO"/>

    <xsl:value-of select="following-sibling::HNS"/>

  </xsl:variable>

  <xsl:if test="$street != ''">

    <street><xsl:value-of select="$street"/></street>

  </xsl:if>

</xsl:template>

<xsl:template match="PRD|POD|STS|HNO|HNS"/>

The other solution requires you to make changes at the civic-address template level, and is much more painful.

xslt concatenation

re: xslt concatenation

re: xslt concatenation

Similar XML bytes

/bytes/development

/bytes/it

/bytes/about