XSLT String Manipulation - Remove spaces in Field Value for use in URL

XSLT function sets the value of a parameter to the value
of the required field, after processing to remove spaces.

The parameter is then used to set part of url in the href attribute of an <a> tag.



<xsl:template name="dvt_1.groupheader0">
 <xsl:param name="fieldtitle" />
 <xsl:param name="fieldname" />
 <xsl:param name="fieldvalue" />
 ....... other template params

 1. Add a parameter to store 

 <xsl:param name="stringNoSpaces" >
 <xsl:call-template name="stringreplace">
  <xsl:with-param name="stringvalue" select="@Field-XPath" />
  <xsl:with-param name="from" select="string(' ')" />
 </xsl:call-template>
 </xsl:param>

 ....... main template code

 <a href="/FirstURLComponent/{$stringNoSpaces}"><xsl:value-of select="$fieldvalue" /></a>

 ....... remaining template code

 </xsl:template>


 2. Add string replace template after the main template:

 <xsl:template name="stringreplace">
   <xsl:param name="stringvalue" />
   <xsl:param name="from" />

   <xsl:choose>
       <xsl:when test="contains($stringvalue, $from)"><xsl:value-of select="substring-before($stringvalue, $from)" />
           <xsl:if test="contains(substring($stringvalue, 1, string-length($stringvalue) - 1), $from)">
            <xsl:call-template name="stringreplace">
             <xsl:with-param name="stringvalue" select="substring-after($stringvalue, $from)" />
             <xsl:with-param name="from" select="$from" />
            </xsl:call-template>
           </xsl:if>
       </xsl:when>
       <xsl:otherwise><xsl:value-of select="$stringvalue" /></xsl:otherwise>
</xsl:choose>
</xsl:template>





The value of the @Field-XPath field will processed by the string replace template to remove all spaces from the string.
The processed string is stored in the stringNoSpaces parameter to be used or displayed by the XSLT template
for a Data View Web Part.

Comments

Post a Comment

Popular posts from this blog

SharePoint Looping Workflow - How to: Loop through and process all items in a list

Image
Objective To use SharePoint workflows to loop through all items in a list to perform calculations, process and update metadata values, or concatenate the value of a specific column in all list items into a single string. Background The OOB workflow actions provided by SharePoint don't allow a loop to be configured explicitly. Instead, a number of workflows can work together to create a looping affect. Another limitation of Workflows in SharePoint using SharePoint Designer (SPD) is the inability to simply test if the user who initiated the workflow is a member of a SharePoint group, or to test if the value of a field in the item which initiated the workflow is equal to the value of a specific field from any item in a separate list. For example, the OOB Approval Workflow requires that a user who is an Approver of changes to approve their own changes each time a modification is made. In many cases, Approvers are also the users who make many of the changes that require content approval...
Read more

Solved: Can't Group By Choice Column in SharePoint List View

By Default, items in a SharePoint list can't be grouped by a Choice field if it allows multiple selections (checkbox). To be able to group by the value of a Choice field in a SharePoint list or library which allows multiple selections, you need to ensure that the Choice field/column is set as Radio Buttons or a Drop Down Menu. Both of these options only allow a single selection of the available choices, which is required to allow grouping by the column/field using Standard SharePoint List views. To group by a Choice field which allows multiple selections (checkboxes), convert the Web Part to a Data View using SharePoint Designer, then apply grouping doing the following: 1. From the "Common Data View Tasks" menu for the Data View Web Part, select "Sort and Group:" from the options to open the Sort and Group Dialog, add any field into the Sort Order section to activate the "Edit Sort Expression..." button. Click the "Edit Sort Expression..." b...
Read more

InfoPath SharePoint: Submit InfoPath form to SharePoint List or Library using Content Type

Image
The following article demonstrates how to integrate an InfoPath form with a SharePoint form library, using a centralised template stored in a SharePoint document library and linked to a site Content Type. The form is set up to submit to a SharePoint form library Overview: Set up SharePoint libraries Design the form template Publish form template to SharePoint Content Type Configure the form's primary data connection to submit to the SharePoint library Secondary Data Connections to receive or submit data to a SharePoint list Setting up SharePoint to store the Form template and receive Submitted forms: If InfoPath Form services are available on your SharePoint server, you have the option to store the form template using Central Administration's managed templates list. To make the form available using this method it must uploaded to the Managed Templates List, the activated for the required site collection. In this example I publish the form template to a ...
Read more