How to trim a string in vb.net

Question

1.00/5 (1 vote)

See more:

Hi everyone,

I have an issue in VB.NET

I have string array.That array contains strings having spaces bothsides(left and right).How do i remove spaces.I am putting string in Datarow.

I am doing like this,but its trimming right side.I want to trim left side also.
Please help me out.

Dim EachLineData() As String = Split(sLine, sCharSep)

dataRw(iCol) = EachLineData(iCol).ToString.PadRight(aColLen(iCol) + 1).Remove(aColLen(iCol)).TrimEnd

Posted 9-Aug-12 23:24pm

DileepkumarReddy

Add a Solution

Comments

Sergey Alexandrovich Kryukov 10-Aug-12 17:54pm

Do you ever read MSDN help?
--SA

4 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)

Aarti Meswania · Answer 1 · 2012-08-09T23:38:00

Solution 2

use only 'Trim' to remove extra spaces from both side, 'TrimEnd' will remove only right-side extra spacing

eg.

VB

dim str as String = "  aaa  ";
          str = str.Trim();

Happy Coding!
:)

Posted 9-Aug-12 23:38pm

Aarti Meswania

Comments

Volynsky Alex 10-Aug-12 5:44am

Good answer aarti meswania !

Aarti Meswania 10-Aug-12 5:45am

thank you! :)

Volynsky Alex 10-Aug-12 6:15am

You are welcome

DileepkumarReddy 10-Aug-12 6:22am

Thanx for the help..

Aarti Meswania 10-Aug-12 8:57am

welcome :)

codeBegin · Answer 2 · 2012-08-09T23:43:00

Solution 3

http://msdn.microsoft.com/en-us/library/d4tt83f9.aspx#Y0[^]
Trim last 4 characters from string[^]

Posted 9-Aug-12 23:43pm

codeBegin

Code-Hunt · Answer 3 · 2012-08-09T23:30:00

Solution 1

Check this once

VB

YourString.Left(YourString.Length-4)

Posted 9-Aug-12 23:30pm

Code-Hunt

Updated 10-Aug-12 10:20am

v2

dhavalmore13986 · Answer 4 · 2012-08-10T01:27:00

Solution 4

VB

Dim str As String = "   mm   aaa   dd     "
 str = str.Replace(" ", "")
 str = str.Trim()

Posted 10-Aug-12 1:27am

dhavalmore13986

Updated 10-Aug-12 10:21am

v2

Comments

Joan M 10-Aug-12 9:42am

Wouldn't the call to "str = str.Trim()" be completely avoidable?