In the primary field, I’m trying to create an ID Code for my ancestors and I need some help.
An example ID Code is:
First three letters of surname, first three letters of name, year of birth
eg Denis O’Brien born in 1836 = ObrDen1836
However, I have ...
augmented:
LEFT(SUBSTITUTE({last name},"’",’’),1)&RIGHT(LEFT(LOWER(SUBSTITUTE({last name},"’",’’)),3),2)
OMG that’s perfect! Thank you so so much Augmented. Have a wonderful day :pray: :grinning_face_with_big_eyes:
augmented:
LEFT(SUBSTITUTE({last name},"’",’’),1)&RIGHT(LEFT(LOWER(SUBSTITUTE({last name},"’",’’)),3),2)
Thank you so much for this help.
I’ve changed all the surnames to uppercase (which is standard in genealogy so that was a great tip) and I...
