Trim string 1

[hamking01]

I'm trying to trim a string that will always end with "AND " and trim this portion off. The string length will be vary time to time so I can't use ltrim. Is there a way for me to do this?

 

[jzelhart]

Try this theory...

C#
strItem.Substring(1,strItem.Length-4);

VB.Net
strSQL.Substring(1, strSQL.Length - 4)

Hope this helps.

Hope everyone is having a great day!

Thanks - Jennifer

 

[chiph]

You can also use String.TrimEnd:

   ' VB.NET
   Dim arr As String() = {"AND "}
   sSQL = sSQL.TrimEnd(arr)

   // C#
   string[] arr = {"AND "};
   sSQL = sSQL.TrimEnd(arr);

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[BoulderBum]

Correct me if I'm wrong, Chip, but I believe TrimEnd() accepts a characater array and removes every instance of all characters.

I don't believe the function will work for this circumstance (and least not without removing all legitimate a's, n's and d's from the end).

[COLOR=blue gainsboro]
Get a FREE iPod by helping me get mine! Click my referrer link:

http://www.freeiPods.com/default.aspx?referer=8158886

More about the company and deal:

http://www.wired.com/news/mac/0,2125,64614,00.html?tw=wn_2culthead

[/color]

 

[chiph]

You are correct -- I didn't read the documentation closely enough. If you look at the sample code, they use a string array, but they're passing null to .TrimEnd, which just removes whitespace.

Good catch.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first