>>So, you would end with MarkGoldin. I'm not sure, this is what you want :)
>
>If a string is 'mark goldin' then yes, but isn't that what you want?
>Mark
Hi Mark,
The original question was how to remove spaces from the middle in the string. Definitely, one last space should be left, otherwise you would have FirstNameLastName without spaces at all. If this string is less than 64K (I hope, it is), reduce function from FoxTools should do its job.
There could be different combinations, say:
Mark Anatolievich Goldin
Mark I Goldin
Mark Goldin Jr.
,
etc.
you should reduce spaces to just one space.
Actually, I have an application written, where I dealt with lots of different name formats to transform them into our standard. It was quite complicated algorithm...
If it's not broken, fix it until it is.
My Blog