Page 1 of 1

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

Posted: Mon May 11, 2015 9:25 pm
by 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="" xmlns:IXML="" xmlns:CMCodeQueryHelper="urn:CMCodeQueryHelper" PackageID="IXML Case Notification Test" MessageID="67077793" xmlns="">
    <Party ID="8265760" InternalPartyID="392728694">
        <PartyName ID="4614549" Current="true" InternalNameID="1612416995">
            <FormattedName>Montemayor-Lira, Ismael</FormattedName>
        <DriversLicense Current="true">
            <DriversLicenseState Word="CDON">Ontario</DriversLicenseState>