[xsl] Extracting data from external file

Subject: [xsl] Extracting data from external file
From: "Joga Singh Rawat" <jrawat@xxxxxxxxxxxxxx>
Date: Mon, 31 Aug 2009 15:20:24 +0530
Hi,
I want to extract data from external file i.e. file_ext.xml but not getting
the required OUTPUT. Can anyone correct me about my mistake.
 
dir/file_ext.xml
<xxx>
  <x a="file_1">
    <y>first</y>
  </x>
  <x a="file _2">
    <y>second</y>
  </x>
</xxx>
 
b.xml
<aaa>
 <b n="file_1">
 <b n="file_2">
</aaa>
 
XSLT Code
<xsl:template match="b">
  <xsl:variable name="a" select="substring-before(@n, '_')"/>
  <xsl:variable name="file" select="document(concat('dir/', $a,
'_ext.xml'))"/>
   <found><xsl:value-of select="$file/xxx/x[@a = @n]/y"/></found>
</xsl:template>
 
OUTPUT
<found>first second</found>
<found>first second</found>
 
Required OUTPUT
<found>first</found>
<found>fsecond</found>
 
Thanks

Current Thread