17 Mar
How to remove thousand separator from a number field of SharePoint using XSLT?
While working with SharePoint numerical columns, we do face situations when we do not need the thousand separator from the numbers. For the same, please use the following code.
<xsl:variable name="MyPrice">
<xsl:choose>
<xsl:when test="contains(@Price, ‘,’)">
<xsl:value-of select="concat(substring-before(@Price, ‘,’), substring-after(@Price, ‘,’))" />
</xsl:when>
<xsl:otherwise>
<xsl:value-of select="@Price" />
</xsl:otherwise>
</xsl:choose>
</xsl:variable>
There is always a better solution to what we do, so if you know anything better, do let me know.