I find the best time to trim these is when you put them together. I usually
do something along the following lines
ltrim$(
rtrim$(
rtrim$(
rtrim$(
rtrim$(Dir + " " + Name
) + " " + Tfare
) + " " + Sufx
) + " " + Zip
)
)
-Mike
> -----Original Message-----
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Saturday, March 11, 2000 3:11 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: MI Remove spaces from text
>
> 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]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
