Bit by bit I think I getting to grips with this. My next problem/issue is I'm trying to un-pack peoples names into Title, first name & last name. The name appears as SMITH/JOHNMR & JONES/ANNEMRS

<Name>SMITH/JOHNMR</Name>

I can extract the last name with:
<xsl:value-of select="substring-before(Name, '/')" />

I've tried getting the length of the name string and then checking the last 2 characters to see if they are "MR" (or "MS"etc.) or the last 3 to see if they are "MRS" or "SIR" etc......

What I've got is:

<xsl:variable name="len" select="string-length(Name)" />
<xsl:choose>
   <xsl:when test="substring(Name, $len-2) = 'MR'">
      <xsl:element name="Title">MR</xsl:element>
      <xsl:element name="FirstName">
         <xsl:value-of select="substring-after(Name, '/')" />
      </xsl:element>
      <xsl:element name="LastName">
         <xsl:value-of select="substring-before(Name, '/')" />
      </xsl:element>
   </xsl:when>
</xsl:choose>
Unfortunately this doesn't seem to work & it will still have the MR at the end of the firstname.

Any ideas anyone?

As always - thanks in advance
:)

Hi, just tried this on localhost:

input XML
------------
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="help1.xsl"?>
<root>
   <Name>SMITH/JOHNMR</Name>
   <Name>JONES/ANNEMRS</Name>
</root>




XSL
---
<?xml version='1.0'?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="html"/>


<xsl:variable name="len" select="string-length(root/Name/text())" />
<xsl:template match="/">
    <xsl:choose>
        <xsl:when test="contains(substring-after(root/Name, '/'), 'MR')">
            <xsl:element name="Title">MR</xsl:element>
            <xsl:element name="FirstName">
                 <xsl:value-of select="substring-after(substring-before(root/Name/text(), substring(root/Name/text(), ($len - 1), 2)), '/')" />
             </xsl:element>
             <xsl:element name="LastName">
                 <xsl:value-of select="substring-before(root/Name, '/')" />
            </xsl:element>
        </xsl:when>
        <xsl:otherwise>
            blah blah
        </xsl:otherwise>
    </xsl:choose>
</xsl:template>

Just been thinking, perhaps try the MRS first, then MISS (changing where MR is & '($len-1),2' bit), otherwise its MR.

That is if you just have MR, MISS & MRS. Would be easier if you had, SMITH/JOHN_MR. Then you could just substring-after(., '_').

Hope this helps in some way. :)

Brilliant, works a treat. Many thanks.

There might be a few problems with titles such as LORD but they are the minority so I'll choose to live with these.

This is all travel related and that's how the name appears on the booking systems etc.

Just in case anyone is interested/cares, I've modified the code slightly to look for the last x characters instead of using "contains" (cuts doen the lines of code):