I Need to get starting 50 words from a string using vb.net

Question

0.00/5 (No votes)

See more:

I am retrieving some product information from database in character format & i need to display only starting 50 words of that information..

Posted 26-Jan-14 22:11pm

ashishtanwar88

Updated 26-Jan-14 22:12pm

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mitchell J. · Accepted Answer · 2014-01-26T22:19:00

Solution 2

Look into the Substring function.

http://www.dotnetperls.com/substring-vbnet[^]

All you need to to is yourstring.Substring(0, 50);

Posted 26-Jan-14 22:19pm

Mitchell J.

Comments

ashishtanwar88 27-Jan-14 5:41am

Initial i was using that information in character (starting 200 characters) but in some cases last word not full displaying.

example :

"In an attempt to facilitate the learning process of students, the book aims at bringing out the conceptual aspects of biochemistry in a magnified view with a complete picture of the context in a diffe"

Last word is difference but it showing only "diffe" because 200 characters limit finished. this issue i need to resolve. I want end of given information with complete word.

I am using sql 2005 with vs 2008. i am retrieving this information from a table named as Book_Information and the column name is Overview.

My current code is :
Dim Bkdesc as String
Bkdesc = RsProdesc("Overview")
Bkdesc = Bkdesc.Substring(0, 200)

ashishtanwar88 · Accepted Answer · 2014-01-27T00:02:00

Solution 3

I have solved this myself by using following code:

Dim Bkdesc as String

Bkdesc = RsProdesc("Overview")
Bkdesc = Bkdesc.Substring(0,200)
Dim LsI As Integer
LsI = Bkdesc.LastIndexOf(" ")
Bkdesc = Bkdesc.Substring(0, LsI)

& Thanks all of you..

Posted 27-Jan-14 0:02am

ashishtanwar88

Updated 27-Jan-14 0:10am

v2

hypermellow · Accepted Answer · 2014-01-26T22:17:00

Solution 1

Usually you would implement the 50 character limitation when retrieving the product information from your database.
As you haven't told us what database system you are using, we can't help you do this.

To do this in VB.NET, have a look at the Left function.
It will enable you to display on a certain amount of characters.

Posted 26-Jan-14 22:17pm

hypermellow

Comments

ashishtanwar88 27-Jan-14 5:25am

Initial i was using that information in character (starting 200 characters) but in some cases last word not full displaying.

example :

"In an attempt to facilitate the learning process of students, the book aims at bringing out the conceptual aspects of biochemistry in a magnified view with a complete picture of the context in a diffe"

Last word is difference but it showing only "diffe" because 200 characters limit finished. this issue i need to resolve. I want end of given information with complete word.

I am using sql 2005 with vs 2008. i am retrieving this information from a table named as Book_Information and the column name is Overview.

My current code is :

Dim Bkdesc as String

Bkdesc = RsProdesc("Overview")
Bkdesc = Bkdesc.Substring(0, 200)

hypermellow 27-Jan-14 5:51am

Have a look at:
http://stackoverflow.com/questions/15909143/use-substring-and-charindex-to-get-last-complete-word-in-field

... it should get you started.