MapInfo Products KnowledgeBase

Product: ExchangeInfo
Version: 5.0 Plus
Platform: Not Platform Related
Category: Product Info

Summary:
Setting up a table of phone numbers for geocoding/joining with ExchangeInfo Plus.

Question:
Setting up a table of phone numbers for geocoding/joining with ExchangeInfo Plus.

Answer:

Follow the steps below to set up a database of phone numbers to be used for geocoding/joining with ExchangeInfo Plus as described here->.

1. Choose File>Open to open the database of phone numbers. The database opens in MapInfo Professional:



This example uses the table Customers.TAB, which contains the fields name and phone. The phone field is in the format NPA-NXX-XXXX (including the dashes). The queries below must be modified if the phone number field has a different format.

2. Choose Query>SQL Select. The SQL Select dialog displays.

3. Enter Cust_Records in the from Tables field.

4. Enter Name, Phone, Left$(Phone,3)”NPA”, Mid$(Phone,5,3)”NXX”, Right$(Phone,4)”Block” in the Select Columns field.

5. Leave the where Condition, Group by Columns, and Order by Columns fields blank.

6. Enter tempCustomers in the into Table Named field. The dialog should look like this:



7. Click OK. The resulting query browser will look like this:



**Optionally the same query above can be run using the MapBasic window and the following syntax:

Select Name, Phone, Left$(Phone,3)"NPA", Mid$(Phone,5,3)"NXX", Right$(Phone,4)"Block" from Cust_Records into tempCustomers
Browse * From tempCustomers

8. Save a copy of TempCustomers using File>Save Copy As. Name the table to something like Customers. Use this new table when geocoding/joining with ExchangeInfo Plus data.

Last Modified:
Document URL: http://testdrive.mapinfo.com/techsupp/miprod.nsf/kbase_by_product/39C50AECCFEF68AE85256C0600626FB1

Setting up a table of phone numbers for geocoding/joining with ExchangeInfo Plus.^39C50AECCFEF68AE85256C0600626FB1^Y