You might export them to MS-Access, and use the Trim$ function to take
the blanks off both ends. Better yet, redo it all with Access, with
several Trim$ in the statement, and get rid of your interior extra
blanks.
Yes, concatenate is the right word.
Ian Straus
> -----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]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
