Hello everyone,
I have an Excel list with many first and last names. For the next process step I need the gender of the person. My idea here was to establish a new attribute (salutation) and fill it with the appropriate form of salutation (Sir or madam). Is this possible with FME?
Thank you very much for your support.
Sounds like an easy way to annoy or even insult the small percentage of those persons who invariably gets the wrong gender, which is almost guaranteed to happen unless you have an authoritative list to match against. Even then, there are many first names that are not gender specific. For some English examples, see e.g. https://www.goodhousekeeping.com/life/parenting/a31401884/gender-neutral-baby-names/
Unless you're OK with that, my personal preference would be to simply use "Dear <firstname> <lastname", or perhaps even "Dear Sir/Madam".
If I were to still power through with the idea using FME, I think I might consider using something like the OpenAIChatGPTConnector and provide as much context as possible.
Sounds like an easy way to annoy or even insult the small percentage of those persons who invariably gets the wrong gender, which is almost guaranteed to happen unless you have an authoritative list to match against. Even then, there are many first names that are not gender specific. For some English examples, see e.g. https://www.goodhousekeeping.com/life/parenting/a31401884/gender-neutral-baby-names/
Unless you're OK with that, my personal preference would be to simply use "Dear <firstname> <lastname", or perhaps even "Dear Sir/Madam".
If I were to still power through with the idea using FME, I think I might consider using something like the OpenAIChatGPTConnector and provide as much context as possible.
I agree with @david_r, if you don't know for sure, don't assume. You're almost guaranteed to get it wrong a few times.