How to remove spaces from within string

[kmagy]

Hi Every Boby

Please help me to remove extra spaces that the user inserted without noticing it inside a string

eg. "abc def" to be "abc def"


Thanks

 

[rob444]

If you have vfp9 use :
trim(stringname,1,' ')
else use "
stringname=strtran(oldstringname,' ','')

Rob.

 

[GriffMG]

This will work:

? STRTRAN( "abc         def"," ","",2)

Regards

Griff
Keep [Smile]ing

 

[alvechurchdata]

remove extra spaces

Just a warning that you'll be removing all the spaces, not just the "extra" spaces. If any of the entries are supposed to have leading or trailing spaces then they'll be removed too.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[TheRambler]

doubleSpace = CHR(32) + CHR(32)
DO WHILE AT(doubleSpace,yourString) > 0
yourString = STRTRAN(yourString,doubleSpace,CHR(32))
ENDDO

 

[TamarGranor]

Look at the Reduce() function in the FoxTools library. It should give you exactly what you need.

Tamar