Great solutions for trimming the excess spaces from begging and trailing.
Thank you for sharing them.
I had a thought about just passing the string using StrAt to find the first and last Character that was not a space and then use SubString on those two numbers?
"...Clarendon Red...."
The full points at begin and end of above represent spaces (. to make visible for example).
StrAt shows the first 3 as spaces and the 4th one as a non Space and sets the start location at 3 - the StrAt func then finds the last NON space to be at position 15 - SubString "...Clarendon Red....", FirstPos, SecondPos-FirstPos)
Would that technique be a fast operation with the processor?
|