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 t

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 nicknam

Re: Peg = Margaret name matching code

2006-09-05 Thread Nathan Strutz
; ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --//-> > > -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

RE: Peg = Margaret name matching code

2006-09-05 Thread Andy Matthews
2006 12:52 AM To: CF-Talk Subject: RE: Peg = Margaret name matching code 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

RE: Peg = Margaret name matching code

2006-09-05 Thread Andy Matthews
Because then you have to enter pairs manually. He's looking for something that's automated. -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

RE: Peg = Margaret name matching code

2006-09-03 Thread Ashwin Mathew
87384.aspx http://www.techonthenet.com/oracle/functions/soundex.php Ashwin www.sanmathi.org -Original Message- From: Mike Chabot [mailto:[EMAIL PROTECTED] Sent: Sunday, September 03, 2006 8:44 PM To: CF-Talk Subject: Peg = Margaret name matching code Does anyone know of code that can match formal

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: > Doe

Peg = Margaret name matching code

2006-09-03 Thread Mike Chabot
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 am mainly interested in names, but matching addresses abbreviation, suc