>>>Not directly in VFP, however, the foxtools library has the function Reduce(). That will handle the removal of spaces appropriately. You might want to look at my Extended Foxtools Help File (under Coding, Syntax and Commands) available in the UT download section.
>>
>>Again, you invoke the wrath of the WSH gods...how about:
>>
>>
oRegExp = CREATEOBJ("Vbscript.RegExp")
>>oRegExp.Global = .t.
>>oRegExp.Pattern = "\s+" && this matches any occurrances of space, tab, ff, CR
>>cVar = oRegExp.Replace(cVar," ")
>
>Unintentionally, I assure you. I was more worried about the foxtools gods< g >.
A likely excuse. And next time, you'll claim "The Devil made me do it!"