Remove Blanks After Last Character in string 1

[Mikeauz]

Hi,

I have a problem where an address looks like
"Art Road " and I'm trying to get rid of the blanks at the end without loosing the blank between the words.

For Example "Art Road " becomes "Art Road"

If I was just trying to trim blanks where a single word was involved I would use:
Left(Street, InStr(1, Street, " ") - 1)

but I'm not sure if that will help with this situation.

Thanks for any help
Mike

 

[PHV]

Replace this:
Left(Street, InStr(1, Street, " ") - 1)
By this:
Trim(Street)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Mikeauz]

PHV. Gold, so simple