How do I check State Code if it has four characters and then

[winkimjr2]

What I am trying to do is check in the XML document for the element

<DriversLicenseState Word="CDON">Ontario</DriversLicenseState>.

If State word found has four characters and begins with ‘CD’ only display the last two characters. In this case (example) I would display <nc:JurisdictionCanadianProvinceCode>ON</nc:JurisdictionCanadianProvinceCode> otherwise display the State/@Word

I am not sure how to add logic to do this.

XML document

Code: Select all

<Integration xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:tsg="http://tsgweb.com" xmlns:IXML="http://tsgweb.com" xmlns:CMCodeQueryHelper="urn:CMCodeQueryHelper" PackageID="IXML Case Notification Test" MessageID="67077793" xmlns="">

    <Party ID="8265760" InternalPartyID="392728694">

        <PartyName ID="4614549" Current="true" InternalNameID="1612416995">

            <NameType>Standard</NameType>

            <NameFirst>Ismael</NameFirst>

            <NameLast>Montemayor-Lira</NameLast>

            <FormattedName>Montemayor-Lira, Ismael</FormattedName>

        </PartyName>

        <DriversLicense Current="true">

            <DriversLicenseNumber>321456782541A</DriversLicenseNumber>

            <DriversLicenseState Word="CDON">Ontario</DriversLicenseState>

        </DriversLicense>

</Integration>