Jason,
From memory it should be ignoring everything after the comma.
If you take a squiz at the MapInfow.ABB file, located wherever you
have MI installed, you will see that it comes after "!EOLNOSPACE"
What you should do is create a new column, specifically for geocoding.
Use Table > Update Column to populate this column.
You should use an expression to rid yourself of the commas.
The following should assist.
Expression:
Left$(Address,InStr(1,Address,",")-1)+Right$(Address,Len(Address)-InStr(1,Address,","))
2 Parts to this Expression: Left$() and Right$()
Left$() extracts from the left, all the letters to the left of the comma
Right$() extracts from the right, all the letters to the right of the comma
You should now be able to geocode using your new column which is an
updated version of your other column as it is sans the comma.
PS This will update all records so you may want to query your table
and update only the records that are applicable.
- Steve
On Tue, 08 Mar 2005 09:18:23 +0000, Jason Murphy
<[EMAIL PROTECTED]> wrote:
> Hi all,
> I am new to geocoding in MapInfo Pro. My target table is a register of
> electors (i.e. 15 Spring Grove, Mill Road) and I am using a standardised
> spatial address database as my source (i.e.15 Spring Grove Mill Road -
> concatenated address lines). There are some "commas" in the target but none
> in the source table. I am finding that in some instances the source records
> are matching even though they have commas whereas others are not. Can anyone
> shed some light on what is going on - does MI ignore commas? Any help
> appreciated. Thanks in advance.
> Jason
>
> ****************************************************************************
> This message is intended only for the person(s) ("The intended
> recipient(s)") to whom it is addressed. It may contain information which is
> privileged and confidential within the meaning of the applicable law.
> If you are not the intended recipient, please contact the sender as soon as
> possible.
>
> The views expressed in this communication may not necessarily be the views
> held by Limerick City Council.
> ****************************************************************************
>
> ---------------------------------------------------------------------
> List hosting provided by Directions Magazine | www.directionsmag.com |
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> Message number: 15585
>
>
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 15634
