<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:fo="http://www.w3.org/1999/XSL/Format">
<xsl:output method="text" />
<xsl:template match="/">
<xsl:apply-templates />
</xsl:template>
<xsl:template match="/extract/formulary/pcg2/pcg6/genericName/pcgGroup/pcg9">
    <xsl:value-of select="/extract/formulary/pcg2/pcg6/@id"/>|<xsl:value-of select="@id"/>
<xsl:text>&#xa;</xsl:text>
</xsl:template>
<xsl:template match="text()" />
</xsl:stylesheet>

- <extract createDate="2009-08-14">
  ......
    <manufacturer id="ZYN">Zymcan Pharmaceuticals Inc.</manufacturer>
  </manufacturerList>
  - <formulary edition="4101" updateVer="K" formularyDate="2009-08-18" createDate="2009-08-14">
    - <pcg2 id="040000000">
      <name>ANTIHISTAMINICS</name>
      - <pcg6>
        - <genericName id="00005">
          <name>CETIRIZINE HYDROCHLORIDE</name>
          - <pcgGroup>
            - <pcg9 id="040000086">
              <itemNumber>0001</itemNumber>
              <strength>10mg</strength>
              <dosageForm>Tab</dosageForm>
              - <drug id="02223554" notABenefit="Y" sec3="Y">
                <name>Reactine</name>
                <manufacturerId>MCL</manufacturerId>
                <listingDate>2007-12-19</listingDate>
              </drug>
              - <drug id="02231603" notABenefit="Y" sec3="Y">
                <name>Apo-Cetirizine</name>
                <manufacturerId>APX</manufacturerId>
                <listingDate>2007-12-19</listingDate>
              </drug>
            </pcg9>
            - <pcg9 id="040000087">
              <itemNumber>0002</itemNumber>
              <strength>20mg</strength>
              <dosageForm>Tab</dosageForm>
              - <drug id="01900978" notABenefit="Y" sec3="Y">
                <name>Reactine</name>
                <manufacturerId>MCL</manufacturerId>
                <listingDate>2008-12-23</listingDate>
              </drug>
              - <drug id="02315963" notABenefit="Y" sec3="Y">
                <name>PMS-Cetirizine</name>
                <manufacturerId>PMS</manufacturerId>
                <listingDate>2008-12-23</listingDate>
              </drug>
            </pcg9>
          </pcgGroup>
        </genericName>
        - <genericName id="00002">
          <name>DIPHENHYDRAMINE HCL</name>
          - <pcgGroup>
            - <pcg9 id="040000014" suppliedBy="L">
              <itemNumber>0003</itemNumber>
              <strength>25mg</strength>
              <dosageForm>Cap</dosageForm>
              - <drug id="00022756" notABenefit="Y" sec3="Y">
                <name>Benadryl</name>
                <manufacturerId>PDA</manufacturerId>
                <listingDate>1996-10-01</listingDate>
              </drug>
              - <drug id="00370517" notABenefit="Y" sec3="Y">
                <name>Allerdryl</name>
                <manufacturerId>VAL</manufacturerId>
                <listingDate>1996-10-01</listingDate>
              </drug>
            </pcg9>
            - <pcg9 id="040000013" suppliedBy="L">
              <itemNumber>0004</itemNumber>
              <strength>50mg</strength>
              <dosageForm>Cap</dosageForm>
              - <drug id="00022764" notABenefit="Y" sec3="Y">
                <name>Benadryl</name>
                <manufacturerId>PDA</manufacturerId>
                <listingDate>1996-10-01</listingDate>
              </drug>
              - <drug id="00271411" notABenefit="Y" sec3="Y">
                <name>Allerdryl</name>
                <manufacturerId>VAL</manufacturerId>
                <listingDate>1996-10-01</listingDate>
              </drug>
            </pcg9>
          </pcgGroup>
        </genericName>
.....