Removing all spaces in a text

[RemingtonSteel]

Hello to everyone!
Is there any function in foxpro that removes all spaces (leading,trailing and even in between) on a text.

For example

Problem = ' Maria de la fuente '
Answer = 'Mariadelafuente'

Thanks in advanced!
Gene

 

[jdhilljr]

This should work for you.

gcString = ' Maria de la fuente '
? STRTRAN(gcString, ' ', '')

If you can't stand behind your troops, stand in front of them.
Semper Fidelis

Jim

 

[RemingtonSteel]

Thanks so much, Jim!

 

[Mike Lewis]

Mike,

My first thought was -- like yours -- to suggest REDUCE(). But it doesn't quite do what Gene requires. It compacts multiple internal spaces to a single space, rather than eliminate them completely.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[SnyAc]

It looks to me like Jim had it on the first reply....

lcString = STRTRAN( lcString, [ ], [] )

Andy Snyder
SnyAc Software Services

http://www.snysoft.com

Hyperware Inc. a division of AmTech Software

http://www.hyperwareinc.com

 

[gfrlaser]

So then, what is the reduce() function really good for?

 

[mmerlinn]

[ ]
More info about removing spaces here: thread184-1262115

mmerlinn

http://mmerlinn.com

"We've found by experience that people who are careless and sloppy writers are usually also careless and sloppy at thinking and coding. Answering questions for careless and sloppy thinkers is not rewarding." - Eric Steven Raymond

 

[Olaf Doschke]

Reduce() is good to keep a single space in between words, just remove unneeded further spaces and whitespace.

Reduce also replaces tabs with a single space. It's main purpose surely is for texts to remove unwanted additional whitespace, but keep a single space for each series of consequtive whitespace.

Gene simply needs a ChrTran(text," ",""). In cases where you process many many texts, ChrTran() itself is 3 times as fast as StrTran() for this kind of single char replacements. And if you want to remove tabs too, do ChrTran(text," "+chr(9),"").

Bye, Olaf.

 

[SnyAc]

Olaf.... good thing to know that CHRTRAN is a faster function than STRTRAN (makes sense though).

Thanks for the info...

Andy Snyder
SnyAc Software Services

http://www.snysoft.com

Hyperware Inc. a division of AmTech Software

http://www.hyperwareinc.com