>>In another language I work with there is a function that will replace multiple spaces with a single space. Is there one for VFP?
>>
>>TIA
>
>Alan,
>
>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," ")