Steve,
It was not clear the way your message was displayed on my machine how many
spaces were between quotes (there was a line break just there). The
original question was to replace more than one space by a single one.
Leading (trailing) blanks can be gotten rid of by LTRIM$ (RTRIM$) function,
but inside ones are more problematic. If you use the "Search and replace"
tool, you should ask to replace two spaces " " by one " ", and repeat the
operation until you are sure that there is not any double space left, but
there is no real way to know it directly.
That is a wish for improving that tool, that a simple message let the user
know how many (if any) replacements have been made.
Jacques Paris
e-mail alternate
[EMAIL PROTECTED] [EMAIL PROTECTED]
paris PC Consult (mainly MapInfo app.)
www.total.net/~rparis/gisproducts.htm
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Steve McArthur
Sent: March 12, 2000 8:54 PM
To: Mike Taylor
Cc: 'MapInfo mail list'
Subject: Re: MI Remove spaces from text
How about simply using the find and replace tool to search for spaces ("
") and replace them with nothing("")
> > > -----Original Message-----
> > > From: David Reid [SMTP:[EMAIL PROTECTED]]
> > > Sent: Thursday, March 09, 2000 7:19 PM
> > > To: [EMAIL PROTECTED]
> > > Subject: MI Remove spaces from text
> > >
> > > Greetins List,
> > >
> > > I've seen something similar to this before but cannot locate. I have
> > > concatenated (if that's a real word) 5 columns; Dir Name Tfare Sufx
> > > & Zip into one; "Street"
> > >
> > > And as you might suspect, I now have many records or "Streets" whos
> > > name begins with a blank space. Also, I have as many records with
> > > two blank spaces between the Street and Zip code.
> > >
> > > How might I move all these unwanted spaces?
> > > ______________
> > > David Reid
> > > [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
