Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Removing extra spaces in MIDDLE of str.
Message
 
To
25/07/2001 13:47:03
Peter Brama
West Pointe Enterprises
Detroit, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00535205
Message ID:
00535649
Views:
15
This will remove occurances of multiple spaces.

lcStr = ALLTRIM(lcOriginalStr) && remove leading and trailing spaces
DO WHILE AT(" ", lcStr) > 0 && look for double space
lcStr = STRTRAN(lcStr, " ", " ", 1, 1) && convert double space to single
ENDDO

I do not know how to get UT to not remove spaces.



>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:
>
>FirstNameLastName
>
>I'd like to strip out the multiple spaces and leave it with just one space.
Dennis Lindeman
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform