Hi all,

I have the following XML-document

And i want to end up with the following textfile:

"1.Some text";"bla bla 1";
"2.Some text";"bla bla 2";

All text in a datarow-element must be on a single line and every br-element must be replaced by a ';'.
I can't seem to remove the newlines that are in the datarow-elements.

Here's my stylesheet. I'm sure it is a minor adjustment.

Many thanks in advance,
Raoul.

I think I have accomplished what you are looking for, try this stylesheet:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:output method="text" encoding="utf-8" />
  <xsl:strip-space elements="*"/>

<xsl:template match="datarows">
    <xsl:for-each select="datarow">
        <xsl:text>"</xsl:text>
            <xsl:apply-templates select="descendant-or-self::*"/>
        <xsl:text>;</xsl:text>

        <xsl:text>#13;</xsl:text>
    </xsl:for-each>
</xsl:template>

<xsl:template match="*">
    <xsl:value-of select="normalize-space(text())"/>
    <xsl:apply-templates select="*"/>
</xsl:template>


I had to make a few changes, such as the recursive template to iterate though each datarow and its descendants to extract the text only. I added the normalize-space function (which is maybe all you needed to do!) to get rid of leading and trailing whitespace in the source. I also output a CR character (#13) instead of the <BR/> tag you were outputting. I'm assuming you wanted a text output, not html. This is a common mistake. You can add the LF char back in, if you need it.

Hope it helps some. I'm sure that there are many other ways to tackle this, but I favor recursion

Looks like I should have review my output before posting. I left out the bla bla.

I'll plug away at it some more

Got it! Try this:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:output method="text" encoding="utf-8" />
  <xsl:strip-space elements="*"/>

  <xsl:template match="datarows">
    <xsl:for-each select="datarow">
      <xsl:text>"</xsl:text>
      <xsl:apply-templates />
      <xsl:text>#13;</xsl:text>
    </xsl:for-each>
  </xsl:template>

  <xsl:template match="br">
    <xsl:text>";</xsl:text>
  </xsl:template>

  <xsl:template match="text()">
    <xsl:value-of select="normalize-space(.)"/>
  </xsl:template>
</xsl:stylesheet>

The above solution is almost correct except for missing quotes. This solution seems to work for me.

Annette.

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:output method="html" encoding="utf-8" />

  <xsl:template match="datarows">
     <xsl:apply-templates />
  </xsl:template>

  <xsl:template match="datarow">
    <xsl:text>"</xsl:text>
    <xsl:apply-templates />
    <xsl:text></xsl:text>
  </xsl:template>

  <xsl:template match="br">
    <xsl:choose>
       <xsl:when test="following-sibling::*">
          <xsl:text>";"</xsl:text>
       </xsl:when>
       <xsl:otherwise>
          <xsl:text>";
</xsl:text>
       </xsl:otherwise>
    </xsl:choose>
  </xsl:template>

  <xsl:template match="text()">
    <xsl:value-of select="normalize-space(.)"/>
  </xsl:template>

</xsl:stylesheet>

Thanks for noticing the error. I get excited when I think I have a solution. My original XSLT will now work with this modification. (not to take anything away from your effort, just to have closure on mine):

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:output method="text" encoding="utf-8" />
  <xsl:strip-space elements="*"/>

  <xsl:template match="datarows">
    <xsl:for-each select="datarow">
         <xsl:apply-templates />
      <xsl:text>#13;</xsl:text>
    </xsl:for-each>
  </xsl:template>

  <xsl:template match="br">
    <xsl:text>";</xsl:text>
  </xsl:template>

  <xsl:template match="text()">
    <xsl:text>"</xsl:text>
    <xsl:value-of select="normalize-space(.)"/>
  </xsl:template>
</xsl:stylesheet>

Hi Raoul!

This will do the trick. The character #x0D is the carriage return. You can't use <br/> because you want a text output.

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output method="text" encoding="utf-8"/>
    <xsl:template match="datarows">
        <xsl:apply-templates/>
    </xsl:template>
    <xsl:template match="datarow">
        <xsl:apply-templates/>
        <xsl:text>#x0D;</xsl:text>
    </xsl:template>
    <xsl:template match="text()">
        <xsl:text>"</xsl:text>
        <xsl:value-of select="normalize-space(.)"/>
        <xsl:text>";</xsl:text>
    </xsl:template>
</xsl:stylesheet>

Just a technicality...both of the above solutions produce extra semi colons.

E.g.
"1.Some text";"bla bla 1";#x0D;"2.Some text";"bla bla 2";#x0D;

Annette.

Hi Annette! It's just that I forgot to put an ampersand before #x0D; (the carriage return).

Have a nice day dear.

RushMan

Dijkstra's law on Programming and Inertia:

If you don't know what your program is supposed to do, don't try to write it.