>>>Is Word2, above, the second word? Counting the separators (the three spaces), it would be the fourth. Depending on how you want to handle this, you may need additional adjustments. Repeatedly replacing a double space with a single space will get rid of unwanted spaces. See strtran().
>>
>>Thank you, Himar,
>>
>>I will keep that in mind.
>>
>>Dawa
>
>Rather than that, why not load FoxTools.fll and use the Reduce(SearchString, [WhatToReplace]) function? If you just pass the SearchString parameter it will remove extra spaces.
>
>Dana
Thank you, Dana for your help,
I've already had the issue resolved. I have written my own function the handle this.
I prefer using built-in function to those of the external unless I have to, so I have fewer items to distribute and/or maintain.
Dawa
Dawa Tsering
"Do not let any unwholesome talk come out of your mouths,
but only what is helpful for building others up according to their needs,
that it may benefit those who listen."
- Ephesians 4:29-30 NIV
Dare to Question -- Care to Answer
Time is like water in a sponge, as long as you are willing you can always squeeze some.
--Lu Xun, Father of Modern Chinese Literature