translate() Function |
Allows you to convert individual characters in a string from one value to another. In many languages, this function is powerful enough to convert characters from one case to another.
Inputs
Three strings. The first is the original, untranslated string, and the second and third strings define the characters to be converted.
Output
The original string, translated as follows: If a character in the original string appears in the second argument string, it is replaced with the corresponding character in the third argument string. In other words, if the character J appears in the original string and J appears as the fourth character in the second argument string, the J is replaced with the fourth character from the third argument string. (Don't worry, we'll have some examples to clear this up in just a minute.) If a character in the original string appears in the second argument string and there is no corresponding character in the third argument string (the second argument string is longer than the third), then that character is deleted. In other words, if the character J appears in the original string, and J appears as the fourth character in the second argument string, and the third argument string is three characters long, the J is deleted. If a character in the second argument string appears more than once, the first occurrence determines the replacement character. If the third argument string is longer than the second argument string, the extra characters are ignored.
Defined in
XPath section 4.2, String Functions.
Example
Here's a stylesheet with several examples of the translate() function:
    <?xml version="1.0"?>
    <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

      <xsl:output method="text"/>

      <xsl:variable name="newline">
    <xsl:text>
    </xsl:text>
      </xsl:variable>

      <xsl:template match="/">
        <xsl:value-of select="$newline"/>
        <xsl:text>Tests of the translate() function:</xsl:text>

        <xsl:value-of select="$newline"/>
        <xsl:value-of select="$newline"/>
        <xsl:text>Convert a string to uppercase:</xsl:text>
        <xsl:value-of select="$newline"/>
        <xsl:text>   translate('Doug', 'abcdefghijklmnopqrstuvwxyz', </xsl:text>
        <xsl:value-of select="$newline"/>
        <xsl:text>             'ABCDEFGHIJKLMNOPQRSTUVWXYZ')=</xsl:text>
        <xsl:value-of select="translate('Doug',
          'abcdefghijklmnopqrstuvwxyz', 'ABCDEFGHIJKLMNOPQRSTUVWXYZ')"/>
        <xsl:value-of select="$newline"/>
        <xsl:value-of select="$newline"/>
        <xsl:text>Convert a string to lowercase:</xsl:text>
        <xsl:value-of select="$newline"/>
        <xsl:text>   translate('Doug', 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', </xsl:text>
        <xsl:value-of select="$newline"/>
        <xsl:text>             'abcdefghijklmnopqrstuvwxyz')=</xsl:text>
        <xsl:value-of
          select="translate('Doug', 'ABCDEFGHIJKLMNOPQRSTUVWXYZ',
                            'abcdefghijklmnopqrstuvwxyz')"/>
        <xsl:value-of select="$newline"/>
        <xsl:value-of select="$newline"/>
        <xsl:text>Remove parentheses, spaces, and dashes</xsl:text>
        <xsl:text> from a U.S. phone number:</xsl:text>
        <xsl:value-of select="$newline"/>
        <xsl:text>   translate('(555) 555-1212', '() -', '')=</xsl:text>
        <xsl:value-of select="translate('(555) 555-1212', '() -', '')"/>
        <xsl:value-of select="$newline"/>
        <xsl:value-of select="$newline"/>
        <xsl:text>Replace all but the last four digits of a </xsl:text>
        <xsl:text>credit card number with Xs:</xsl:text>
        <xsl:value-of select="$newline"/>
        <xsl:variable name="credit" select="'4918 3829 9920 1810'"/>
        <xsl:text>   $credit='</xsl:text>
        <xsl:value-of select="$credit"/>
        <xsl:text>'</xsl:text>
        <xsl:value-of select="$newline"/>
        <xsl:text>   translate(substring($credit, 1, 15), </xsl:text>
        <xsl:text>'1234567890 ', 'XXXXXXXXXX-')</xsl:text>
        <xsl:value-of select="$newline"/>
        <xsl:text>   substring($credit, 16)</xsl:text>
        <xsl:value-of select="$newline"/>
        <xsl:value-of select="$newline"/>
        <xsl:text>   The first part is </xsl:text>
        <xsl:value-of
          select="translate(substring($credit, 1, 15), '123457890 ',
            'XXXXXXXXX-')"/>
        <xsl:value-of select="$newline"/>
        <xsl:text>   The second part is </xsl:text>
        <xsl:value-of select="substring($credit, 16)"/>
        <xsl:value-of select="$newline"/>
        <xsl:value-of select="$newline"/>
        <xsl:text>   Here's how they look together: </xsl:text>
        <xsl:value-of
          select="translate(substring($credit, 1, 15), '123457890 ',
            'XXXXXXXXX-')"/>
        <xsl:value-of select="substring($credit, 16)"/>
      </xsl:template>

    </xsl:stylesheet>
When we use this stylesheet with any XML document, here are the results:
    Tests of the translate() function:

    Convert a string to uppercase:
       translate('Doug', 'abcdefghijklmnopqrstuvwxyz',
                 'ABCDEFGHIJKLMNOPQRSTUVWXYZ')=DOUG

    Convert a string to lowercase:
       translate('Doug', 'ABCDEFGHIJKLMNOPQRSTUVWXYZ',
                 'abcdefghijklmnopqrstuvwxyz')=doug

    Remove parentheses, spaces, and dashes from a U.S. phone number:
       translate('(555) 555-1212', '() -', '')=5555551212

    Replace all but the last four digits of a credit card number with Xs:
       $credit='4918 3829 9920 1810'
       translate(substring($credit, 1, 15), '1234567890 ', 'XXXXXXXXXX-')
       substring($credit, 16)

       The first part is XXXX-XXXX-XXXX-
       The second part is 1810

       Here's how they look together: XXXX-XXXX-XXXX-1810