First name gender association 1

[RivetHed]

Hi folks,

Does anyone out there possess a table of first names together with appropriate titles (Mr or Ms), I'm doing a data clean up and it would save me a lot of time if someone else has done this before and could give me a copy.

Thanks!

 

[TomCologne]

This address might be helpful if nobody comes up with a list:

http://www.aussiethings.com.au/babynames/index.htm

It is sorted by gender and then alphabetically, but it imports really well into Excel and from there it may still be easier than a manual clean up.

You're not alone,

TomCologne

 

[RivetHed]

you have just saved me so much work, have a star!

 

[TomCologne]

My pleasure and thanks for the star.

TomCologne

 

[SoloDroid]

Eeek! I hope you really want to do that. Names like Kelly, Terry, and even Randy can go either way. Your clients may be offended if they receive a salutation for the wrong gender. Robert
•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•
Professional, affordable, Access database solutions and assistance

http://www.SoloDroid.com

°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°

 

[RivetHed]

yeah I know I've had a quick skip through for unisex names, but thanks for the warning anyway

 

[RivetHed]

Actually this is only a part of what I'm doing, first of all generate titles through first name association (having removed unisex names) and then use it a bit like a spellcheck, there are a lot of duplicate customers within this data and I'm currently consolidating them together. Duplicates have been identified by a matching company and a partial string match on the contact name so a list of appropriate names allows me to choose which of two similar but not exactly the same names to give precedence (there are a lot of spelling mistakes in this data as well).
I've never done a big de-dupe like this before so any general purpose hints or tips would be gratefully received