?
Solved

How do I use substring in xsl?

Posted on 2013-01-15
6
Medium Priority
?
223 Views
Last Modified: 2013-01-18
Hi,

I have the below xsl code:

<xsl:value-of select="substring(@Description,1,250)" disable-output-escaping="yes" />
<xsl:if test="string-length(@Description) &gt; 250">...</xsl:if>

Open in new window


This displays the first 250 characters of the description, and "..." if there are more characters in the description than being displayed. How can I alter this so only 50 characters are displayed? When I changed both instances of "250" to "50" no text was shown?

Thanks.
0
Comment
Question by:aspnet-scotland
  • 4
  • 2
6 Comments
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 38780444
well, did you not change anything else?

changing 250 to 50 in both instances is the way to go

maybe you only have spaces in the first 50 chars?
0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 38780456
maybe you need to tell us what happens next to the result of this XSLT
Maybe you have a process in place that removes a text if not long enough

Bottomline as an answer to your question is
250 to 50 should work in this isolated case
but check what happens next
0
 

Author Comment

by:aspnet-scotland
ID: 38780512
Strange....when I reduced it to "100" only around 20 characters were shown, I guess there must be white space hidden somewhere as firebug doesn't show anything?

Thanks.
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 60

Accepted Solution

by:
Geert Bormans earned 2000 total points
ID: 38780545
Well, if it is bigger than 50, you should see the "..."

A browser does away with spurious white-space
A good test could be

<xsl:variable name="norm-desc" select="translate(normalize-space(@Description), ' ', '_')"/>
<xsl:value-of select="substring($norm-desc,1,250)" disable-output-escaping="yes" />
<xsl:if test="string-length($norm-desc) &gt; 250">...</xsl:if>

Open in new window


This takes out all sequences of whitespace in favour of a single underscore
(if you leave out the normalize-space, you will see all spaces as underscore)

It will help you to guess the number of whitespace in your input
0
 

Author Comment

by:aspnet-scotland
ID: 38782064
Thanks for your code. I can see that all whitespace have now been replaced with an underscore but no rogue whitespace seems to be present. I seem to have lost around 50 characters somewhere. Strange.

Thanks.
0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 38782077
Maybe if you could post the source XML and the full stylesheet, that could help
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

The Client Need Led Us to RSS I recently had an investment company ask me how they might notify their constituents about their newsworthy publications.  Probably you would think "Facebook" or "Twitter" but this is an interesting client.  Their cons…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
If you are looking for an automated tool which can generate reports for Outlook emails and other items from PST file, then you can go for Kernel PST Reporter tool. The reports which are created by this tool are helpful to analyze and understand PST …
Watch the video to know the simple way to remove or recover or reset lost or forgotten passwords of Outlook PST file. With Kernel Outlook Password Recovery tool such operation is very easy to perform. It is a freeware with limitation to use with 500…

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question