How to get only 20 characters from left side

Question

4.00/5 (1 vote)

See more:

Here is my sql command

select top 10 * from comment inner join list on list.id=comment.id where status=1 order by comment_time desc

I want to create like this

string str=comments.aspx?id="+dr["id"]+">"+dr["comment_body"]

In the comment body i need only 20 characters.

Please any one can help me.
Thanks in advance

i used the above solution but it shown error like

MSIL

Index and length must refer to a location within the string.
Parameter name: length

i am using data type as ntext

Posted 30-Jun-11 21:24pm

rahul dev123

Updated 30-Jun-11 22:02pm

v5

Add a Solution

6 solutions

Solution 5

string commentBody = (string)dr["comment_body"];
if(commentBody.Length > 20) commentBody = commentBody.Substring(0, 20);
string str = "comments.aspx?id="+dr["id"]+">" + commentBody;

Posted 30-Jun-11 23:48pm

BobJanova

Solution 6

try that way. Checking the length also if the length is greater than 20.

string str = "comments.aspx?id=" + dr["id"] + ">" + (Convert.IsDBNull(dr["comment_body"]) ? "" : dr["comment_body"].ToString().Substring(0, dr["comment_body"].ToString().Length > 20 ? 20 : dr["comment_body"].ToString().Length -1));

Posted 1-Jul-11 1:36am

nit_singh

Solution 4

try this

VB

Dim st As String = "returing 20 characters from left side to the string."
        Dim chSt() As Char = st.ToCharArray()
        Array.Reverse(chSt)
        st = New String(chSt).Substring(0, 19)
        Label1.Text = st

Posted 30-Jun-11 22:35pm

prem shanker verma

Comments

BobJanova 1-Jul-11 5:46am

In English locales, 'from the left' means from the beginning.

Henry Minute 1-Jul-11 7:38am

This does not answer the OPs question.
Why are you reversing the string? Totally unnecessary.
Why Substring(0, 19)? the OP wanted 20 characters, not 19.

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)

Vivek Krishnamurthy · Accepted Answer · 2011-06-30T21:31:00

Solution 3

This can be done in 2 places

1. in the query - better place if you have no other use of the full comment

using substring function, refer to
SUBSTRING (Transact-SQL)[^]

2. in c#

using String.Substring method, refer to
String.Substring Method (Int32, Int32)[^]

Posted 30-Jun-11 21:31pm

Vivek Krishnamurthy

Comments

Pete O'Hanlon 1-Jul-11 3:57am

And this, is the correct advice. Good job.

Christian Graus 1-Jul-11 4:24am

Note that good advice is never accepted. Code that can be copied blindly by idiots, who have no idea why it works, or why it sometimes doesn't, is the order of the day.

Toniyo Jackson · Accepted Answer · 2011-06-30T21:28:00

Solution 2

Try this.

string str=comments.aspx?id="+dr["id"]+">"+dr["comment_body"].Substring(0, 20);

Posted 30-Jun-11 21:28pm

Toniyo Jackson

Comments

Abhinav S 1-Jul-11 3:29am

We both posted at the same time. Even the seconds were same. :)
My 5.

Toniyo Jackson 1-Jul-11 3:33am

:). It should be 20. 20 is the length

Pete O'Hanlon 1-Jul-11 3:56am

He's taken 20 characters. The second parameter is the length, not the index to end at.

Abhinav S · Accepted Answer · 2011-06-30T21:28:00

Solution 1

string str=comments.aspx?id="+dr["id"]+">"+Convert.ToString(dr["comment_body"]).SubString(0,20);

Posted 30-Jun-11 21:28pm

Abhinav S

Updated 1-Jul-11 0:11am

v2

Comments

Toniyo Jackson 1-Jul-11 3:34am

My 5 too Abhinav. :)

vivekse 1-Jul-11 3:38am

What happen if comment has less than 20 character? length must be checked before doing SubString.

Toniyo Jackson 1-Jul-11 3:46am

OP has to work on that.

Toniyo Jackson 1-Jul-11 3:39am

It should be 20. 20 is the length

Abhinav S 1-Jul-11 6:11am

Yup my bad. Thanks for pointung that out.

rahul dev123 1-Jul-11 3:49am

Thanks for your solution but it shown error like indexOutOfRange

Christian Graus 1-Jul-11 4:23am

Well, are you a programmer at all ? Can you read ? What do you THNK index out of range means ? This code assumes the string is 20 chars long. You need to check if it is, and if not, don't ask for more chars than exist.