Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How do I use substring in xsl?

Posted on 2013-01-15
6
Medium Priority
?
217 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
The Orion Papers

Are you interested in becoming an AWS Certified Solutions Architect?

Discover a new interactive way of training for the exam.

 
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

Amazon Web Services EC2 Cheat Sheet

AWS EC2 is a core part of AWS’s cloud platform, allowing users to spin up virtual machines for a variety of tasks; however, EC2’s offerings can be overwhelming. Learn the basics with our new AWS cheat sheet – this time on EC2!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
The Confluence of Individual Knowledge and the Collective Intelligence At this writing (summer 2013) the term API (http://dictionary.reference.com/browse/API?s=t) has made its way into the popular lexicon of the English language.  A few years ago, …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

721 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