Dave
try this - the same functions appear in EXCEL and MapInfo, might be easier
to do in EXCEL as a series of columns
assuming all the street addresses are in the same format I'd
1) get rid of any leading blank spaces using LTRIM() function
2) search for the first appearance of a blank in the remaining string. The
INSTR() function will return a position we'll call it "X" for now
3) take 1 from "X"
4) use the Left$() function to return the first "X" characters
no doubt there are many other ways but the above will work, in EXCEL each
part could be a column with a formula in, teh final columnn should have the
required answe
hope this helps
PS what are you doing working on Saturday....
Mick
----- Original Message -----
From: Dave Lagerstedt <[EMAIL PROTECTED]>
To: mapinfo-l <[EMAIL PROTECTED]>
Sent: Saturday, April 08, 2000 3:25 PM
Subject: MI remove street names from address
I have a table with a column of street addresses such as "14963 140th St."
I want to remove the "140th St" portion and be left with just "14963" in
either that column or another column. Can this be done in Mapinfo or Excel?
If so how?
Thank you
Dave Lagerstedt
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
