Here is the challenge I have for you if your day is slow. I have a
system I am working on that is used in both USA and Canada. The
parameters for the challenge:
* US zip codes are formatted *99999-9999*
* Canadian Postal codes are formatted *A9A 9A9* -- the space is correct.
* My trusty R:Docs 9.1 does not show an option for a dbedit to change
the format of the field on entry so that I can look up the country
associated with the entry and change the format to the country
specific format.
* I do not want to maintain two columns when one text 10 column will do.
* Any geniuses out there that can figure this one out?
I already have a format checker in the exit eep that catches most user
errors, but it would be nice to make the zip code field like the date
and phone fields where the user just types away and doesn't worry about
capital letters and spaces and hyphens.
I can happily live with the situation as is, but this is one of those
"I'm sure it can be done, but ..." situations.
Have fun!
Albert
