deleting empty strings

[Matrix.net]

Hi can someone give me a hand on figuring out how i would delete the empty strings from the end of a string? currently I've built a function that builds a query based on user input , the thing is that it will add empty strings to the rest of the query if they dont pick certain things . The number of empty strings and length of the string is unknown because it depends on the user and what they pick. heres an example of what I need to do : lets say based on user input , my function ends up with a query string like : "Select field1,field2,field3 from tablea,tableb where field1 = field2____________________________________" (all that space at the end is what I need to get rid of)

Im working on it currently but it would be nice if someone could also help me look into this while I'm at it. I know theres functions to delete strings but since my case is not that simple it's gonna take a little thought to figure this one out.

[Phil Weber]

Try this: In Visual Studio, declare a string variable and assign it a value with several spaces at the end:

Dim MyString As String = "x                   "

Now, on the next line, type the name of the string variable (MyString), followed by the period character (.); you'll see a dropdown list of the actions you can perform on that variable. Scroll through the list and see if one of them looks useful. ;-)

[Matrix.net]

Try this: In Visual Studio, declare a string variable and assign it a value with several spaces at the end:

Dim MyString As String = "x                   "

Now, on the next line, type the name of the string variable (MyString), followed by the period character (.); you'll see a dropdown list of the actions you can perform on that variable. Scroll through the list and see if one of them looks useful. ;-)

thanks but like I said above I already did that. The problem isnt deleting the blanks, its trying to figure out at which point in the string there is nothing but blanks and then delete from that point till the last blank/empty string is deleted.

[Phil Weber]

Did you try MyString.TrimEnd?

[Matrix.net]

Did you try MyString.TrimEnd?

I didnt try it because the description didnt sound like it was what I needed. Maybe you can give me a clearer explenation of what it does? Thanks

[edburdo]

Try the help file on TrimEnd.

It trims all blankspace from the END of the string (leaving any blankspace in the front or middle of the string alone.

[Matrix.net]

Try the help file on TrimEnd.

It trims all blankspace from the END of the string (leaving any blankspace in the front or middle of the string alone.

thanks, I resolved the issue last night though. It just had to do with me not having single quotes around certain things and having them around things I shouldn't . I will make a note of that however.