Re: Peg = Margaret name matching code

2006-09-06 Thread Mike Chabot
I think using a database table, like Pete suggested, is a decent solution. The issues I was hoping to avoid were the tedious data entry, quality assurance testing, and keeping it updated. That is why I was hoping for something open-source or a professional product. There are products that do this

RE: Peg = Margaret name matching code

2006-09-05 Thread Andy Matthews
: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Sunday, September 03, 2006 5:58 PM To: CF-Talk Subject: Re: Peg = Margaret name matching code Why not just create two database tables, one with id(int) and formalname(varchar), the second with formalnameid(int) and nickname(varchar) and populate

RE: Peg = Margaret name matching code

2006-09-05 Thread Andy Matthews
. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ashwin Mathew [mailto:[EMAIL PROTECTED] Sent: Monday, September 04, 2006 12:52 AM To: CF-Talk Subject: RE: Peg = Margaret name matching code Mike, I think you're looking for a soundex (http

Re: Peg = Margaret name matching code

2006-09-05 Thread Nathan Strutz
--//- -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Sunday, September 03, 2006 5:58 PM To: CF-Talk Subject: Re: Peg = Margaret name matching code Why not just create two database tables, one with id(int) and formalname(varchar), the second with formalnameid(int

Re: Peg = Margaret name matching code

2006-09-05 Thread Robert Munn
Why not write a package that does it? You even have a name for it- Peg! Does anyone know of code that can match formal names, such as Michael with their less formal equivalents, such as Mike. I was starting to code this but stopped after realizing that there were thousands of these nicknames. I

Re: Peg = Margaret name matching code

2006-09-03 Thread Pete Ruckelshaus
Why not just create two database tables, one with id(int) and formalname(varchar), the second with formalnameid(int) and nickname(varchar) and populate starting with names from the URL you mentioned, then bounce your names against that? Pete On 9/3/06, Mike Chabot [EMAIL PROTECTED] wrote: Does

RE: Peg = Margaret name matching code

2006-09-03 Thread Ashwin Mathew
Mike, I think you're looking for a soundex (http://en.wikipedia.org/wiki/Soundex), which does a sounds like comparison. I know that Oracle and SQL Server support soundex in the database - that might be the easiest thing to do. http://msdn2.microsoft.com/en-us/library/ms187384.aspx