Jump to content

How do I check State Code if it has four characters and then transform it to 2 character code?


winkimjr2

Recommended Posts

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>
<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>

XSLT code

<xsl:template name="ChargeDetails"><nc:IdentificationJurisdiction>    <nc:JurisdictionCanadianProvinceCode>        <xsl:for-each select="/Integration/Party/DriversLicense[@current='true']/DriversLicenseState">            <xsl:if test="/Integration/Party/DriversLicense[@current='true']/DriversLicenseState[@Word]">            <xsl:value-of select="substring(/Integration/Party/DriversLicense[@Current='true']/DriversLicenseState/@Word, 1, 2)"/>            </xsl:if>        </xsl:for-each>    </nc:JurisdictionCanadianProvinceCode></nc:IdentificationJurisdiction>
Edited by winkimjr2
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...