Solved

# Canadian postal codes in IVR system

Posted on 2004-09-20
561 Views
This is a simple one.  I need to know the easiest way for a user to enter a Canadian postal code on a telephone keypad.  Since it's alphanumeric, I can't let them use just numbers.  I need a real easy way.  I have a database of 800,000 postal codes which when translated into significant number combinations has hundreds of thousands of duplicates.  What methods do the big guys use?

Ed
0
Question by:lehman6676

LVL 16

Accepted Solution

jimbobmcgee earned 250 total points
ID: 12111832
Just an idea (bearing in mind I am unfamiliar with Canadian Post Code):

Each of the keys on a standard telephone keypad correspond to a series of letters:
2 = a,b,c,
3 = d,e,f,
4 = g,h,i
5 = j,k,l
6 = m,n,o
7 = p,q,r,s
8 = t,u,v
9 = w,x,y,z

You will need to check for up to five presses of the same button (by tone?), since some buttons contain four letters (+ the number itself is five presses).  Get the user to press x number of times (the first press being the number) and use # or * key in between:

eg: ABC 1234 = 1,1,#,1,1,1,#,1,1,1,1,#,1,#,2,#,3,#,4,#
FJS 7890 = 3,3,3,3,#,5,5,#,7,7,7,7,7,#,7,#,8,#,9,#,0,#

Out of interest, the UK post code system also contains letters.  I have yet to come across a telephone-based system for entry -- usually it is a voice-recognition/manual check process (but I assume you are trying to avoid this).

HTH
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…