Hi,

I do not know a lot of XSL. However I need to find a way where I can filter data from FMPro7 in order to generate a xml file correctly.

In my database I have a field with five possible values: m, v, mv, an, nv

In my xsl stylesheet I want to filter these values to a simple "yes" or "no"

In the xsl I want to do something like this:

<artist> when fmp:COL[8]/fmp:DATA[1] = m

<xsl:attribute name="MALE"><xsl:text>yes</xsl:text></xsl:attribute>

<xsl:attribute name="FEMALE"><xsl:text>no</xsl:text></xsl:attribute>

when fmp:COL[8]/fmp:DATA[1] = v

<xsl:attribute name="MALE"><xsl:text>no</xsl:text></xsl:attribute>

when fmp:COL[8]/fmp:DATA[1] = mv

<xsl:attribute name="MALE"><xsl:text>yes</xsl:text></xsl:attribute>

<xsl:attribute name="FEMALE"><xsl:text>yes</xsl:text></xsl:attribute>

and then: else:

<xsl:attribute name="MALE"><xsl:text>no</xsl:text></xsl:attribute>

<xsl:attribute name="FEMALE"><xsl:text>no</xsl:text></xsl:attribute>

Could anyone help me out? I know I should go deeper into this but i think it

It is kind of complicated. But fortunately this part of it is very much like a FileMaker If, ElseIf, Else script construct. In xsl it's "choose, when, otherwise".

<xsl:choose>

<xsl:when test="fmp:COL[1]/fmp:DATA='m'">

<xsl:attribute name="MALE"><xsl:text>yes</xsl:text></xsl:attribute>

<xsl:attribute name="FEMALE"><xsl:text>no</xsl:text></xsl:attribute>

</xsl:when>

<xsl:when test="fmp:COL[1]/fmp:DATA='v'">

<xsl:attribute name="MALE"><xsl:text>no</xsl:text></xsl:attribute>

<xsl:attribute name="FEMALE"><xsl:text>yes</xsl:text></xsl:attribute>

</xsl:when>

<xsl:when test="fmp:COL[1]/fmp:DATA='mv'">

<xsl:attribute name="MALE"><xsl:text>yes</xsl:text></xsl:attribute>

<xsl:attribute name="FEMALE"><xsl:text>yes</xsl:text></xsl:attribute>

</xsl:when>

<xsl:otherwise>

<xsl:attribute name="MALE"><xsl:text>no</xsl:text></xsl:attribute>

<xsl:attribute name="FEMALE"><xsl:text>no</xsl:text></xsl:attribute>

</xsl:otherwise>

</xsl:choose>

Artistsxml.zip

Thanks Fenton!

You're the best :