Problem accessing an element

[rosemm]

I am having a problem accessing an element in an XML document (one that
I receive from someone else). The xml looks like this

<FAMILY>
<DAD>
<ADDRESS>
<ADDRESS_LINE VALUE="SOMETHING"/>
<ADDRESS_LINE VALUE="SOMETHING ELSE"/>
...................
</ADDRESS>
<MOM>
</MOM>
</FAMILY>
<FAMILY>
<DAD>
<ADDRESS>
<ADDRESS_LINE VALUE="SOMETHING"/>
..............
</ADDRESS>
<MOM>
</MOM>
</FAMILY>

I am creating a CSV. I need to have an , , if there is no second
ADDRESS_LINE. However, I can't even seem to access the second address
line in my code. Here is what I have so far.


<xsl:value-of select="normalize-space(ADDRESS_LINE/@VALUE)"/>
<xsl:text>,</xsl:text>
<xsl:value-of select="ADDRESS/CITY/@VALUE"/>
<xsl:text>,</xsl:text>
<xsl:value-of select="ADDRESS/STATE/@VALUE"/>
<xsl:text>,</xsl:text>
<xsl:value-of select="ADDRESS/ZIP/@VALUE"/>
<xsl:text>,</xsl:text>

Help!!!

 

[Joris Gillis]

I am creating a CSV. I need to have an , , if there is no second
ADDRESS_LINE. However, I can't even seem to access the second address
line in my code. Here is what I have so far.

Hi,

Try this:

<xsl:value-of select="normalize-space(ADDRESS_LINE[1]/@VALUE)"/>
<xsl:text>,</xsl:text>
<xsl:value-of select="normalize-space(ADDRESS_LINE[2]/@VALUE)"/>
<xsl:text>,</xsl:text>
<xsl:value-of select="ADDRESS/CITY/@VALUE"/>
<xsl:text>,</xsl:text>
<xsl:value-of select="ADDRESS/STATE/@VALUE"/>
<xsl:text>,</xsl:text>
<xsl:value-of select="ADDRESS/ZIP/@VALUE"/>
<xsl:text>,</xsl:text>


regards,

 

[rosemm]

That doesn't work. I get the following error

ERROR: Description: Expression must evaluate to a node-set.
-->normalize-space(ADDRESS/ADDRESS_LINE[1]/@VALUE)<--

 

[rosemm]

Thanks. I typed something else wrong. That soultion works perfect!!!