XSLT - Remove Special Characters Function

Remove Special Characters Function

Which ever characters are allowed, provide it in the select. Anything other than provided characters will be considered as special characters.

<xsl:function name="stripSpecialChars">

    <xsl:param name="string" />

    <xsl:variable name="AllowedSymbols" select ="'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789()*%$#@!~&lt;&gt;,.?[]=- +   /\ '"/>

    <xsl:value-of select="translate($string,translate($string, $AllowedSymbols, ''),' ')"/>

</xsl:function>

<xsl:value-of select="stripSpecialChars($string)"/>

For your information -

&lt;  ---> Less Than Symbol

&gt; ---> Greater Than Symbol

XSLT - Calculate Week Number based on date

 Calculate Week Number based on date

Template with Parameters:

Defining Template 1- [This template calls another template below]

   <xsl:template name="calculate-week-number">
        <xsl:param name="year"/>
        <xsl:param name="month"/>
        <xsl:param name="day"/>
        
        <xsl:variable name="j-day">
            <xsl:call-template name="calculate-julian-day">
                <xsl:with-param name="year" select="$year"/>
                <xsl:with-param name="month" select="$month"/>
                <xsl:with-param name="day" select="$day"/>
            </xsl:call-template>
        </xsl:variable>
        
        <xsl:variable name="d4" 
            select="($j-day + 31741 - ($j-day mod 7)) 
            mod 146097 mod 36524 mod 1461"/>
        
        <xsl:variable name="L" select="floor($d4 div 1460)"/>
        
        <xsl:variable name="d1" select="(($d4 - $L) mod 365) + $L"/>
        
        <xsl:value-of select="floor($d1 div 7) + 1"/>
        
    </xsl:template>

Defining Template 2 - [Used by above template]

    <xsl:template name="calculate-julian-day">

        <xsl:param name="year"/>

        <xsl:param name="month"/>

        <xsl:param name="day"/>

        

        <xsl:variable name="a" select="floor((14 - $month) div 12)"/>

        <xsl:variable name="y" select="$year + 4800 - $a"/>

        <xsl:variable name="m" select="$month + 12 * $a - 3"/>

        

        <xsl:value-of select="$day + floor((153 * $m + 2) div 5) + $y * 365 + 

            floor($y div 4) - floor($y div 100) + floor($y div 400) - 

            32045"/>

        

    </xsl:template>

Calling Template - [The returned value is stored in the variable WeekNumber]

<xsl:variable name="WeekNumber">            

    <xsl:call-template name="calculate-week-number">

        <xsl:with-param name="day" select="day-from-date($Start_Date)"/>

        <xsl:with-param name="month" select="month-from-date($Start_Date)"/>

        <xsl:with-param name="year" select="year-from-date($Start_Date)"/>

    </xsl:call-template>

</xsl:variable>

XSLT Functions with Examples

 XSLT Functions with Examples

Always remember while you are coding XSL Transformation, your input for your xsl is XML. 

i.e. your XSL code is based on the XML.

Below are most commonly used XSLT coding functions and methods. This is not an exhaustive list though.

How to Declare a variable:

<xsl:variable name="Newline" select="'&#xa;'"/>

<xsl:variable name="Tab" select="'&#9;'"/>

                <xsl:variable name="NumberFormat" select="'0.00'"/>

                <xsl:variable name="DateFormat" select="'[M01]/[D01]/[Y0001]'"/>

                <xsl:variable name="Pipe" select="'|'"/>

                <xsl:variable name="SplChar" select="'$@!%^&*()- '"/>

                <xsl:variable name="FillerZeros" select="'0000000000000000000000'"/>

How to use the variable which was declared: [Use $]

          <xsl:value-of select="$Newline"/>

Simple Text:

    <xsl:text>Test</xsl:text>

Concat Function:

   Example1:    <xsl:value-of select="concat(wd:Email,$Pipe)"/>

   Example2: <xsl:value-of select="concat('Y',$Pipe)"/>

Translate Function: [Use when you want to replace something]

       <xsl:value-of select="translate(wd:phone, '+().- ', '')" />

Sort Usage:

        <xsl:sort select="wd:Location"/>  

String-length Function:

         <xsl:when test="string-length(wd: Zip) = 8">  

Your Values Here

         </xsl:when>

Exists Function:

           <xsl:when test="exists(wd:Primary_Email)">   

Your Values Here

           </xsl:when>

Count Function:

   Example 1:        <xsl:value-of select="count(//wd:Report_Entry)"/>

   Example 2:        <xsl:value-of select= "count (//wd:Report_Entry[wd:Benefits/wd:Coverage='Family']/wd:Dependents)"/>

Format Date Function:

     Example 1:   <xsl:value-of select="format-date(current-date(),'[Y0001]-[M01]-[D01]')"/>

     Example 2:   <xsl:value-of select="format-date(wd:DateOfBirth,'[Y0001][M01][D01]')"/>

Format Number Function:

    <xsl:value-of select="format-number(wd:amount,$numberFormat)"/>

Substring Function:

         <xsl:value-of select="substring(wd:Work_Phone,3,10)"/>

Substring Before Function:

        <xsl:value-of select="substring-before(wd:Division/@wd:Descriptor,':')"/>

If Condition:

    <xsl:if test="wd:Gender = 'M'">

             .

             .            

            Your code here

             .

             .

    </xsl:if>

Choose and When Function:

  <xsl:choose> 

             <xsl:when test="(wd:Worker_Status = 'On Leave')"> 

                     <xsl:value-of select="'L'"/> 

             </xsl:when>

             <xsl:otherwise> 

                     <xsl:value-of select="'A'"/> 

             </xsl:otherwise> 

 </xsl:choose>

'For' Loop Function:

    Example 1:

   <xsl:for-each select="wd:Report_Data/wd:Report_Entry">

             .

             .            

            Your code here

             .

             .

       </xsl:for-each> 

    Example 2: [Using Group-by]

        <xsl:for-each-group select="wd:Report_Data/wd:Report_Entry" group-by="wd:Location">

             .

             .            

            Your code here

             .

             .

       </xsl:for-each> 

Other Text conditions in When Fuction:

Condition 1:

          <xsl:when test="(wd:Class_Item = '001' or wd:Class_Item = '002')">     

Your Values Here

  </xsl:when>

Condition 2:

         <xsl:when test="(wd:Benefits[1]/wd:Enrolment_Date) != ''">

Your Values Here

         </xsl:when> 

Condition 3:

         <xsl:when test="(wd:Class_Item = '002' and wd:Benefit_Changes[1]/wd:SubType ='T')">    

Your Values Here

         </xsl:when>

Template Declaration and Usage:

Calling Templates -

    <xsl:template match="/">

        <xsl:call-template name="HeaderRecord"/>

        <xsl:call-template name="DetailRecords"/>

    </xsl:template>

Defining Template -

    <xsl:template name="HeaderRecord">

             .

             .            

            Your code here

             .

             .

    </xsl:template>