How about simply using the find and replace tool to search for spaces ("
") and replace them with nothing("")
Mike Taylor wrote:
>
> 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]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
