>Is there any VFP routines that can remove (or replace) multiple space occurances in the middle of a string?
>
>I am processing data from another source. The NAME comes across as:
>
>FirstName
LastName
>
>I'd like to strip out the multiple spaces and leave it with just one space.
SUBSTR(lcName, 1, AT(' ', lcname)) + ALLTRIM(SUBSTR(lcName, AT(' ', lcName)))
Mark McCasland
Midlothian, TX USA
