Remove Trailing Spaces

[exus]

I wrote a script that would take data from edit boxes in my works proprietary program and put it into an Excel spreadsheets, that we use as delivery paperwork. I got it to pull data and put it into cells just fine except for one small problem, there is a set limit that can be typed in the boxes and it takes the info plus all the blank spaces after it. This only gives me a problem in one spot, there are two edit boxes for location, one for city and one for state. Here's a snippet of my code that inputs the data into a cell in Excel.

Send($LocationCity)
Send(", ")
Send($LocationST)

But when it grabs the data for the city it takes what is typed in and all the set space available in the box (a limit of 20 characters) so I end up with an output of something like

San Jose             , CA

(it was removing the extra spaces in my example automagically)

Is there a way to get rid of the extra spaces at the end of the string I store the city data in so the comma will be next to the city name like it should be?

[Jos]

Is there a way to get rid of the extra spaces at the end of the string I store the city data in so the comma will be next to the city name like it should be?

StringStripWs() ?

[Monamo]

StringStripWs() ?

Just be sure to use 3 as a flag to allow for spaces within the city name (ex: Kansas City).

[exus]

Hahaha, thank you very much, worked perfectly.

I knew there had to be an easy way to do this but seeing as how this is only the second script I've ever written in AutoIt I'm not familiar with all the functions yet.

[RDSchaefer]

Hahaha, thank you very much, worked perfectly.

I knew there had to be an easy way to do this but seeing as how this is only the second script I've ever written in AutoIt I'm not familiar with all the functions yet.

RTFM

[xcal]

RTFM

What the hell was the point of that, so after the fact?