Since you don't want to use foxtools and reduce function: x = " this is a test" DO WHILE x<>STRTRAN(x,SPACE(2),SPACE(1)) x=STRTRAN(x,SPACE(2),SPACE(1)) ENDDO ?x
Not the most efficient, but it does work. Fred On Mon, Jan 24, 2011 at 2:58 PM, Jack Skelley <[email protected]>wrote: > Good Afternoon: > I am trying to take text from a Word doc and put it into a memo field. But > what is happening is the unjustified text in Word doc is putting multiple > spaces between the words in the memo field where there is a line feed from > the Word doc. > I have a method I wrote years ago to remove the multiple spaces but don't > want to use it because it is in a loop. > I half way remember someone posted a function to do this. But can't find > it. > I tried stuff() and strtran() but can't get it right because of the > variable number of spaces between 1 line to the next. > Does anyone remember the function to strip a variable number of spaces into > 1 space? Or was I dreaming? > Thanks! > Regards, > > Jack Skelley > <a href="http://devils.nhl.com/";><IMG SRC= > http://c1.newjerseydevils.com/sig/[email protected]="0"; > usemap="#Map"></a> > <map name="Map"> > <area shape="rect" coords="4,67,203,85" href=" > http://devils.nhl.com/club/page.htm?id=65573"; target="_blank"> > <area shape="rect" coords="269,67,346,87" href="http://www.prucenter.com/"; > target="_blank"> > <area shape="rect" coords="243,43,264,62" href=" > http://www.youtube.com/prudentialcenter"; target="_blank"> > <area shape="rect" coords="223,43,244,62" href=" > http://twitter.com/nhldevils"; target="_blank"><area shape="rect" > coords="203,43,224,62" href=" > http://www.facebook.com/NewJerseyDevils?ref=ts"; target="_blank"> > </map> > </A> > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
