MatchFirstName ( Name1, Name2, ShowMatchList )

Used to help match/merge duplicate client entries (should always try matching with email/phone/birthdate first)
Be the first to rate this function Log in to vote
Kyle Williams - Show more from this author
Augusto Digital
https://www.youtube.com/channel/UCpJlB7cmVNMjbjgY96MEsng
Sample input:
MatchFirstName ( "Christina", "Tina", 0 )
MatchFirstName ( "Kevin", "Kyle", 0 )
MatchFirstName ( "Phillip", "", 1 )
Sample output:
1
0
"PHILLIP¶PHIL" (Return delimited list of found names)
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
//AUTHOR:         Kyle Williams
//DATE:              9/1/2019
//Last Update:    10/29/2019
//PURPOSE:        Help to eliminate duplictive client records, provides another level of matching after email, phone number, & birthday
//NOTES:            Function will try to match with the first name of each row first (name), if no found matches, it will try matching with a nickname/alternative name.
//                       If still no match is found, it will use the given Name1 and try to match it with Name2
//			  Name1 is the source name, Name2 is the name you're trying to match it with. The result is boolean. 
//			  If you would like to see what names it is returning from Name1, enter a 1 for "ShowMatchValues" (useful for troubleshooting)

Let([
Name1 = Substitute( Upper( Trim(LeftWords( Substitute (Name1; [ "."; " " ] ; [ ","; " " ]  ); 1 ) )); "È"; "E");
Name2 = Substitute( Upper( Trim(LeftWords( Substitute (Name2; [ "."; " " ] ; [ ","; " " ]  ); 1 ) )); "È"; "E");
list = "" & ¶ &
"AARON,ERIN,RON,RONNIE,ARON," & ¶ &
"ABEL,AB,ABE,EB,EBBIE," & ¶ &
"ABIEL,AB,ARIEL, ABEL,ABE,BIEL" & ¶ &
"ABIGAIL,ABBY,GAIL,GAIL,NABBY," & ¶ &
"ABNER,AB," & ¶ &
"ABRAHAM,AB,ABE," & ¶ &
"ABRAM,AB,ABRAHAM,ABE," & ¶ &
"ADALINE,ADA,ADDY,DELIA,DELL,LENA,ADELINE," & ¶ &
"ADELAIDE,ADDY,ADELE,DELL,DELLA,HEIDI,ADDIE," & ¶ &
"ADELPHIA,ADDY,ADELE,DELL,DELPHIA,PHILLY," & ¶ &
"AGATHA,AGGY," & ¶ &
"AGNES,AGGY,INEZ,NESSA," & ¶ &
"AIDAN,AIDEN,AIDRIEN,AIDRIAN,ADDY,ADDIE," & ¶ &
"AILEEN,ALLIE,LENA," & ¶ &
"AL,ALFONSE,ALBERT, BERT,ALISON,ALLY,ALISSA,ALAN,ALAIN," & ¶ &
"ALBERT,AL,BERT," & ¶ &
"ALBERTA,ALLIE,BERT,BERTIE," & ¶ &
"ALDO,AL," & ¶ &
"ALDRICH,RICH,RICHE," & ¶ &
"ALEXANDER,AL,ALEX,SANDY," & ¶ &
"ALEXANDRA,ALEX,ALLA,SANDRA,SANDY,ALLY,ALEXIS,ALEXA,LEXA" & ¶ &
"ALFONSE,AL," & ¶ &
"ALFRED,AL,FRED,FREDDY," & ¶ &
"ALFREDA,ALFY,FREDA,FREDDY,FRIEDA," & ¶ &
"ALICE,ALLIE,ELSIE,LISA," & ¶ &
"ALICIA,ALLIE,ELSIE,LISA,ALI," & ¶ &
"ALLAN,AL," & ¶ &
"ALLISANDRA,ALLIE,ALISON,ALLISON,ALI,ALLI," & ¶ &
"ALMENA,ALLIE,MENA," & ¶ &
"ALONZO,AL,LON,LONZO," & ¶ &
"AMANDA,MANDA,MANDY,AMNDA," & ¶ &
"ANDERSON,ANDY," & ¶ &
"ANDREW,ANDY,DREW,ANDRE,ANDREA," & ¶ &
"ANGELA,ANG,ANJ,ANJI,ANGEL,ANGIE,GEE,ANGELIQUE,ANGEL,ANGELA,ANG,ANGIE,ANGI," & ¶ &
"ANISHA,PRASHANT," & ¶ &
"ANN,ANNIE,NAN,NANA,NANCY,NANNY,ANNA,LIZZY,AN,LINDA,ANASTASIA,STACEY,ANNE,ANNIE,NAN,NANA,NANCY,NANNY,ANNAMARIE,MARIE," & ¶ &
"ANTHONY,TONY,ANTONIO,TONY," & ¶ &
"ANTOINETTE,ANN,NETTA,TONY," & ¶ &
"ANTONIA,ANN,NETTA,TONY," & ¶ &
"ARABELLA,ARA,ARRY,BELLA,BELLE,ARABELLE,ARA,ARRY,BELLA,BELLE," & ¶ &
"ARCHIBALD,ARCHIE," & ¶ &
"ARLENE,ARLY,LENA," & ¶ &
"ARMENA,ARRY,MENA," & ¶ &
"ARTHUR,ART," & ¶ &
"ASAHEL,ASA," & ¶ &
"ASAPH,ASA," & ¶ &
"ASENATH,ASSENE,NATTY,SENE," & ¶ &
"AUGUST,GUS," & ¶ &
"AUGUSTINA,AGGY,GATSY,GUSSIE,TINA,AUGUSTA," & ¶ &
"AUGUSTINE,AUGUSTUS,AUGUST,AUSTIN,GUS," & ¶ &
"AUTUMN,AUTUMNE," & ¶ &
"AVANINDRA,AVI,AVITANIA,TANIA," & ¶ &
"AZARIAH,AZE,RIAH," & ¶ &
"BARBARA,BAB,BABS,BARBY,BOBBIE," & ¶ &
"BARNABAS,BARNEY," & ¶ &
"BARTHOLOMEW,BART,BARTEL,BAT,MEES,MEUS," & ¶ &
"BEATRICE,BEA,TRISHA,TRIX,TRIXIE," & ¶ &
"BELINDA,BELLE,LINDA," & ¶ &
"BENEDICT,BEN,BEN,BENNIE" & ¶ &
"BENJAMIN,BEN,BENJY,BENNIE,JAMIE," & ¶ &
"BERNARD,BARNEY,BERNEY,BERNIE," & ¶ &
"BERTHA,BERT,BERTIE,BIRDIE," & ¶ &
"BEVERLY,BEVERLEY,BEV," & ¶ &
"BETH,BETHANY," & ¶ &
"BETSY,BETSEY,BETSIE,BESSY," & ¶ &
"BILL,FRED,BILLY,BILLIE,FREDDY," & ¶ &
"BILLY,FRED," & ¶ &
"BRADFORD,BRAD,FORD,BRADLEY," & ¶ &
"BRADLEY,BRAD," & ¶ &
"BREANN,BRE,BRIANNA,BREANNA,BRIEANN,BRIE,BRIANNE,BRIANN," & ¶ &
"BRIDGET,BIDDIE,BIDDY,BRIDGIE,BRIDIE," & ¶ &
"BRITTNEY,BRITTANY,BRITNY,BRITNEY,BRITANY,BRITT,BRIT," & ¶ &
"BRODERICK,BRADY,BRODY,RICK,RICKY," & ¶ &
"CALVIN,CAL,VIN,VINNY," & ¶ &
"CAMERON,CAM,RON,RON,RONNY," & ¶ &
"CAMILLE,CAMMIE,MILLIE," & ¶ &
"CAROL,CARRIE,CASSIE,LYNN,KERRI,KERRY,CARRY,CAREY,CARREY,CARIE,CARY,KARY,KARRY,KARRIE,KARIE,KURI,KURY,KURRI,KURRIE,CURRY,CURRIE,CURY,CURRIE,CURI,CURRI," & ¶ &
"CAROLANN,CAROL,CAROLE,CAROLYN,CAROLINE,CAROL,CAROLE,CAROLYN,CARRIE,CASSIE,LYNN," & ¶ &
"CASEY,KC,CASE,CASS," & ¶ &
"CASSANDRA,CASSIE,SANDRA,SANDY," & ¶ &
"CECILIA,CELIA,CISSY," & ¶ &
"CEDRIC,CED,RICK,RICKY," & ¶ &
"CHAD,CHARLES,CHADWICK," & ¶ &
"CHAND,CHANG," & ¶ &
"CHARLES,CARL,CHARLIE,CHICK,CHUCK,CHARLRS,CHAD,CHARYLIE," & ¶ &
"CHARLOTTE,CHAR,LOTTA,LOTTIE,SHERRY,CHARLIE,CARLY,CHERYL,CHERLY," & ¶ &
"CHAUNCEY,CHAN," & ¶ &
"CHESTER,CHET," & ¶ &
"CHRIS,CHRISTOPHER,CHRISTIAN,CHRISTO,KIT,KRISTINE,CHRISTY,CRISSY,KRIS,KRISTY,CHRISTINA,CHRISTINE,KRISTEN,CHRISTIANA,CHRISSY,CRISTOPHER,CRIS,CR,KIRTSEN,KIRSTEN,KRISSEY,KRISTEN,CHRIS,KRISSY,KRISS,KRISTIN,KRISTINA,KRISTIN,CHRIS,CHRISSY,KRISSY,KRISS,KRIS,KRISTINE,CHRIS,CHRISTY,CRISSY,KRIS,KRISTY,TINA,CHRISTA,CHRIS,CHRISTIANA,CHRISTY,CRISSY,KRIS,KRISTY,TINA,CHRISTINE,KRISTEN,KRISTIN,CHRISTINA,KRSTIN," & ¶ &
"CHRISTIAN,CHRIS,CHRIS,KIT," & ¶ &
"CHRISTIANA,ANN,CHRIS,CHRISTY,CRISSY,KRIS,KRISTY,TINA,CHRISTA,CHRISTIANE,CHRIS," & ¶ &
"CHRISTINA,CHRIS,CHRISTY,CRISSY,KRIS,KRISTY,TINA,CHRISTA,KRISTY,CHRISTINE,CHRISSY,CATHERINE," & ¶ &
"CLARENCE,CLAIR,CLARE," & ¶ &
"CLARINDA,CLARA," & ¶ &
"CLARISSA,CISSY,CLARA,LARISSA,LORISSA," & ¶ &
"CLEMENT,CLEM," & ¶ &
"CLIFFORD,CLIFF,FORD," & ¶ &
"CLIFTON,CLIFF,TONY," & ¶ &
"COLLEN,COLLEEN,COLEN,CALEN," & ¶ &
"COLUMBUS,CLUM," & ¶ &
"CONRAD,CON,CONNY,Konrad," & ¶ &
"CONSTANCE,CONNIE," & ¶ &
"CORDELIA,CORDY,DELIA," & ¶ &
"CORNELIA,CORNIE,CORNY,NELIA,NELLE,NELLY," & ¶ &
"CORNELIUS,CON,CONNY,CORNY,NIEL," & ¶ &
"COURTNEY,COURT,CURT,CORT,CORTNEY," & ¶ &
"CURTIS,CURT," & ¶ &
"CRYSTAL,CYSTAL," & ¶ &
"CYNTHIA,CINDY,CIND,CINTHA,SYNTHIA,SINTHIA," & ¶ &
"CYRENIUS,CENE,CY,RENIUS,SERENE,SWENE," & ¶ &
"CYRUS,RUSTY,RAY,RUSS,CY," & ¶ &
"DAL,DAHL," & ¶ &
"DALTON,DAHL," & ¶ &
"DANIEL,DAN,DANNY,DANA,DANASEKAR,DHANASEKAR," & ¶ &
"DANIELLE,DANI," & ¶ &
"DARLENE,DARRY,LENA," & ¶ &
"DAVID,DAVE,DAVEY,DAY,DAAVID,DAVIDS," & ¶ &
"DEBORA,DEB,DEBBIE,DEBBY,DEBORAH,DEB,DEBBIE,DEBBY,DEBY,DEBRA,DEBRA,DEB,DEBBIE," & ¶ &
"DIEDRA,DEDRA,DEIRDRE,DEIDRE," & ¶ &
"DELBERT,BERT,DEL," & ¶ &
"DELIVERANCE,DELLA,DELLY,DILLY," & ¶ &
"DELORES,DEE,DELL,DELLA,LOLA,LOLLY," & ¶ &
"DENNIS,DENNY,DENNISON,DENNI," & ¶ &
"DERRICK,ERIC,RICK,RICKY," & ¶ &
"DIANA,DIANNE,DANA,DEE,ANA,ANNA,DIANNA," & ¶ &
"DICEY,DICIE," & ¶ &
"DOMENIC,DOM,DOMINIC," & ¶ &
"DONALD,DON,DONNIE,DONNY,DONY," & ¶ &
"DORCUS,DARKEY," & ¶ &
"DOROTHY,DOLLY,DORTHA,DOT,DOTTY," & ¶ &
"DOUGLAS,DOUG," & ¶ &
"EBENEZER,EB,EBBIE,EBEN," & ¶ &
"EDMOND,EDMUND,ED,EDDIE,EDDY,NED,TED,EDUARDO,ED,EDDIE,EDDY,EDWARD,ED,EDDIE,EDDY,NED,TED,TEDDY,EDWIN,ED,EDDIE,EDDY,NED,WIN,EDGAR,ED,EDDIE,EDDY," & ¶ &
"EDITH,EDIE,EDYE,EDYTH,EDIE,EDYE," & ¶ &
"EDYTHE,EDIE,EDYE," & ¶ &
"ELBERT,ALBERT," & ¶ &
"ELEANOR,ELAINE,ELLEN,ELLIE,LANNA,LENORA,NELLY,NORA," & ¶ &
"ELEAZER,LAZAR," & ¶ &
"ELIAS,ELI,LEE,LIAS,ELLIOT,ELLIOTT," & ¶ &
"ELIJAH,ELI,LIGE," & ¶ &
"ELIPHALET,LEFT," & ¶ &
"ELISHA,ELI,LISH," & ¶ &
"ELIZABETH,BESS,BESSIE,BETH,BETSY,BETTY,ELIZA,LIB,LIBBY,LISA,LIZ,LIZA,LIZZIE,LIZZY,LYNN,LUNN,LUPE," & ¶ &
"ELLSWOOD,ELSEY" & ¶ &
"ELMIRA,ELLIE,ELLY,MIRA," & ¶ &
"ELOUISE,LOUISE," & ¶ &
"ELSWOOD,ELSEY,ELWOOD,WOODY,EL,ELS,ELSIE,ELSEY," & ¶ &
"ELZE,ELSEY," & ¶ &
"EMANUEL,MANNY,MANUEL," & ¶ &
"EMELINE,EM,EMILY,EMMA,EMMY,MILLY,EMILIE,EMILY,EMMA,EMMY,MILLIE,AMELIA,AMY,EMILY,MEL,MILLIE," & ¶ &
"ENEDINA,DINA," & ¶ &
"EPAPHRODITIUS,DITE,DITUS,DYCE,DYCHE,EPPA," & ¶ &
"EPHRAIM,EPH," & ¶ &
"ERIC,RICK,RICKY," & ¶ &
"ERICA,ARYKA,ERICKA,ERIKA,ARIKA," & ¶ &
"ERMIN,EJ," & ¶ &
"ERNEST,ERNIE," & ¶ &
"ESTELLA,ESTELLE,ESSY,STELLA," & ¶ &
"EUFEMIA,EUFELIA," & ¶ &
"EUGENE,GENE," & ¶ &
"EUN,ANGELA," & ¶ &
"EVALINE,EVA,EVE,LENA,EVANGELINE,EVA,EVIE,EVELYN," & ¶ &
"EZEKIEL,EZ,ZEKE," & ¶ &
"EZRA,EZ," & ¶ &
"FAITH,FAY,FAEGHEH,FEY,FAYE," & ¶ &
"FELTIE,FELTY," & ¶ &
"FERDINAND,FERDIE,FRED,FREDDIE,FREDDY," & ¶ &
"FIDELIA,DELIA," & ¶ &
"FLORENCE,FLO,FLORA,FLOSSY," & ¶ &
"FRANCES,CISSY,FANNY,FRANCIE,FRANKIE,FRANNIE,FRANNIEY,SIS,FRANCIS,FRAN,FRANK,FRANKIE " & ¶ &
"FRANCINE,FRAN,FRANCIE,FRANNIE,FRANNIEY," & ¶ &
"FRANKLIN,FRAN,FRANK," & ¶ &
"FRANKLIND,FRANK,FRANKLIN,FRANKY,FRANK" & ¶ &
"FREDERICK,FRED,FRED,FREDDIE,FREDDY,FREDDY,FRITZ," & ¶ &
"FREDERICKA,FREDA,FREDDY,FRIEDA,RICKA," & ¶ &
"FRIEDA,FRED,FREDDIE,FREDDY," & ¶ &
"GABRIEL,GABBY,GABE,GABRIELE,GABI,GABRIELLA,ELLA,GABB,GABRIELLE" & ¶ &
"GEMELIA,GEM," & ¶ &
"GEOFFREY,GEOFF,JEFF," & ¶ &
"GERALD,GERRY,JERRY," & ¶ &
"GERALDINE,DINA,GERRIE,GERRY,JERRY," & ¶ &
"GERTRUDE,GERT,GERTIE,TRUDY," & ¶ &
"GILBERT,BERT,BERT,GIL,WILBER," & ¶ &
"GOKAN,GOKHAN,GOHKAN,KHAN," & ¶ &
"GREGORY,GREG, GREGOR," & ¶ &
"GUANYU,GARRY," & ¶ &
"GWENDOLYN,GWEN,WENDY," & ¶ &
"HANNAH,ANNA,NAN,NANN," & ¶ &
"HAOYU,CHRISSY," & ¶ &
"HAROLD,HAL,HARRY," & ¶ &
"HARRIET,HATTIE," & ¶ &
"HELEN,HELENE,ELLA,ELLEN,ELLIE,LENA,CHELEN," & ¶ &
"HELOISE,ELOISE,ELOUISE,LOIS," & ¶ &
"HENRIETTA,ETTA,ETTY,HANK,NETTIE,RETTA," & ¶ &
"HENRY,HAL,HANK,HARRY,HENK,HENDRICK,HENDRIK,HENRIK,HENRICK,RICK,DRAKE,HANKS,HENKS," & ¶ &
"HEPHSIBAH,HIPSIE," & ¶ &
"HEPSIBAH,HIPSIE," & ¶ &
"HERBERT,BERT,HERB," & ¶ &
"HERMIONE,HERM,HEMMIE,HERMIE,MINNIE,MINEY,OWNIE,ERMA,HERMA,HERMIA,HERMINA,HERMINE, " & ¶ &
"HESTER,ESTHER,HESSY,HETTY," & ¶ &
"HEZEKIAH,HEZ,HY,KIAH," & ¶ &
"HIRAM,HY," & ¶ &
"HOPKINS,HOP,HOPP," & ¶ &
"HORACE,HORRY," & ¶ &
"HUBERT,BERT,BERT,HUB,HUGH," & ¶ &
"HUMBERTO,BERTO,BERT," & ¶ &
"IGNATIUS,IGGY,NACE,NATE,NATIUS," & ¶ &
"IRENE,RENA," & ¶ &
"IRVING,IRV," & ¶ &
"ISAAC,IKE,ZEKE," & ¶ &
"ISABEL,BELL,BELLA,BELLE,IB,ISSY,NIB,NIBBY,TIBBIE," & ¶ &
"ISABELLA,ISABELLE,BELLA,BELLE,IB,ISSY,NIB,NIBBY,TIBBIE," & ¶ &
"ISADORA,DORA,ISSY,DOROTHEA,DARCY," & ¶ &
"ISIDORE,IZZY,ISAIAH,IZZIE,IZZI,LIZZY," & ¶ &
"JACOB,JAAP,JAKE,JAY,JAY," & ¶ &
"JACOBUS,JACOB," & ¶ &
"JACQUELINE,JACKIE,JACQUELYN,LYN,LYNN,JACQUI,JACLYN,JACKLYN,JACKLIN," & ¶ &
"JAMES,JAMIE,JEM,JIM,JIMMIE,JIMMY,JAIME,JAIMIE,JAIMY,JAMISON,JAIMISON," & ¶ &
"JANE,JANIE,JEAN,JENNIE,JESSIE,JANNET,JANET,,JAN,JESSIE,JANICE,JEANNIE,JEANETTE,JANET,JEAN,JESSIE,NETTIE,JEANNE,JANE,JEANNIE," & ¶ &
"JEDIDIAH,JED," & ¶ &
"JEFFERSON,JEFF,SONNY,JEFFREY,GEOFF,JEFF," & ¶ &
"JEHIEL,HIEL," & ¶ &
"JEMIMA,MIMA," & ¶ &
"JENNIFER,JENN,JENNIE,JENNY,JEN,JENNI,GENEVIEVE,EVE,JEAN,JENNY,GENEVEIVE,GENEVEEVE,GENEVEAVE,GENE,JEANIE," & ¶ &
"JEREMIAH,JEREME,JERRY,JEREMY,JARED,JARRED,GERED,JERRY,JEREMEY," & ¶ &
"JESSICA,JESSIE,JESS,JESSI," & ¶ &
"JOAN,JO,NONIE," & ¶ &
"JOANN,JO,JOANE,JOANNE,JOANNA,HANNAH,JO,JOAN,JODY," & ¶ &
"JOANNE,JO," & ¶ &
"JOHANNA,JO," & ¶ &
"JOHANNAH,HANNAH,JOAN,JODY,NONIE," & ¶ &
"JOHN,JACK,JOCK,JOHNNY,JON,JOHN,NATHAN,JONATHAN,JHONATHON,JHONATHAN,JOHNATHAN,JONATHEN," & ¶ &
"JOSEPH,JODY,JOE,JOEY,JOS,JOSS,JOACHIM," & ¶ &
"JOSEPHINE,FINA,JO,JODY,JOEY,JOSEY," & ¶ &
"JOSHUA,JOS,JOSH,JOSS," & ¶ &
"JOSIAH,JOS," & ¶ &
"JOYCE,JOY," & ¶ &
"JUANITA,NETTIE,NITA," & ¶ &
"JUDSON,JUD,SONNY," & ¶ &
"JUDY,JUDITH,JUD,JUDIE," & ¶ &
"JULIA,JILL,JULIE,JULIANNE,JULI,JULLIE,JULIAS,JULE," & ¶ &
"JULIAN,JULE,JULY" & ¶ &
"JUNIOR,JR,JUNE,JUNIE," & ¶ &
"JUSTIN,JUSTI,JUSTING," & ¶ &
"KARLY,KARLEIGH,CARLY,CARLEIGH,CARLIE,KARLIE," & ¶ &
"KASEY,KC,CASE,CASS," & ¶ &
"KATELIN,KATELYN,KATE,KAY,KAYE,KATLYN,KATY,KATHERINE,KAT,KATRINA,CATRINA,CAT,CAITLIN,CATE,KATE,KATEY,KATLIN,KATELIN,KAELIN,KAELYN,CAIT,KATIE,CASSIE,CATHY,KATE,KATHY,KATY,KAY,KAYE,KIT,KITTIE,LENA,TRINA,TASSA,KATHLEEN,CASSIE,CATHY,KATHY,KATHY,KATY,KAY,KIT,KITTIE,LENA,TRINA,LENY,KATHLYNE,CATHERINE,CATHARINE,CASSIE,CATHY,KATHY,KATY,KAY,KIT,KITTIE,LENA,TRINA,CAT,CATHY,KAREN,KATY,KATHRYN,KATEY,KATY,KAT,CAT,CATHY,CATHERINE,KATE,KATHERINE,KATHY,CATHLEEN,CASSIE,CATHY,KATHY,KATY,KAY,KIT,KITTIE,LENA,TRINA,CATIE,KATHERYN,KATHRYN,KATJANA,KATIJANA," & ¶ &
"KATIA,LISA," & ¶ &
"KAV,KAVANAUGH," & ¶ &
"KALEY,KAYLEY,KAY,CALEY,CALY," & ¶ &
"KENDALL,KEN,KENNY," & ¶ &
"KENNETH,KEN,KENDRICK,KENNY," & ¶ &
"KENT,KEN,KENDRICK,KENNY," & ¶ &
"KEZIAH,KIZZA,KIZZIE," & ¶ &
"KIMBERLEY,KIM,KIMMY,KIMBERLY,KYM," & ¶ &
"KINGSLEY,KING," & ¶ &
"KINGSTON,KING," & ¶ &
"KYLE,KIEL," & ¶ &
"KYLIE,KYLA,KYLE,KIELY,KELLY," & ¶ &
"LAFAYETTE,FATE,LAFFIE," & ¶ &
"LAMONT,MONTY," & ¶ &
"LANETTTE,LANETTE,LANEY,LANE,ANETTE,NETTE," & ¶ &
"LAURENCE,LARRY," & ¶ &
"LAURIE,LORRY,LORI,LORY,LAURY,LAUREE,LOREE,LORELL,LAUREL,LAURELL,LORA,LAURA,LAURI,LORY,LOREY,LAUREN,LORNA,LORNY,LORNIE,LAURA,LARA," & ¶ &
"LON,LONNY,LORNE,LORRY," & ¶ &
"LAVINA,LAVINIA,INA,VINA,VINEY," & ¶ &
"LARRY,LAWRENCE,LARRY,LON,LONNY,LORNE,LORRY," & ¶ &
"LEMAILOA,LEMA," & ¶ &
"LEMUEL,LEM," & ¶ &
"LENORA,LEE,NORA," & ¶ &
"LEONARD,LEN,LENNY,LEO,LEON,LINEAU," & ¶ &
"LEROY,L.R.,LEE,ROY," & ¶ &
"LESLIE,LES,SLY,LESLIANNE," & ¶ &
"LESTER,LES," & ¶ &
"LETITIA,LETTICE,LETTIE,TISH,TITIA," & ¶ &
"LEVI,LEE," & ¶ &
"LIDIA,LYDDY," & ¶ &
"LILIAN,LILLAH,LIL,LILLY,LIL,LILLIAN,LIL,LILLY,LOLLY," & ¶ &
"LINCOLN,LINK," & ¶ &
"LINDA,LINDY,LYNN," & ¶ &
"LISA,ALICE,MELISSA," & ¶ &
"LOIS,LOUISE,LOU,LU,,LOSI," & ¶ &
"LORENZO,LOREN," & ¶ &
"LORETTA,ETTA,LORRIE,RETTA," & ¶ &
"LORRAINE,LORRIE," & ¶ &
"LOUISA,LOUISE,ELIZA,LOIS,LOU," & ¶ &
"LUCILLE,CILLE,LOU,LU,LUCY," & ¶ &
"LUCINDA,CINDY,LOU,LU,LUCY," & ¶ &
"LUELLA,ELLA,LU,LULA," & ¶ &
"LUTHER,LUKE,LUCAS,LUKE,LUCIAS," & ¶ &
"LYDIA,LYDDY,LYNDON,LINDY,LYNN," & ¶ &
"MADELINE,LENA,MADDY,MADGE,MAGDA,MAGGIE,MADELEINE,MADDIE,MAGDELINA,LENA," & ¶ &
"MAHALA,HALLIE," & ¶ &
"MALINEE,MALINI,MALINY,MAIOLAYNE,MALANA,MALENA,MALIN,MALINA,MALINE,MALINEY,MALINIE,MALONIE,MALONY,MALOUNAI,MALYNI,MEILIEN,MEILANI,MELAINEY,MELAINIE,MELANEY," & ¶ &
"MARCUS,MARK,MARC,MARKUS,MARKEY,MARKY," & ¶ &
"MARGARET,DAISY,GRETTA,MADGE,MAGGIE,MAGGY,MARGE,MARGERY,MARGIE,MARGIE,MARGY,MEG,MIDGE,PEG,PEGGY,PEGGY,RITA,MARGARET,MARGOT,MAGS,MARGARETTA,MARJORIE,MARGY," & ¶ &
"MARTHA,MARTY,MAT,MATTIE,PATSY,PATTY," & ¶ &
"MARTIN,MARTY," & ¶ &
"MARTINA,TINA," & ¶ &
"MARVIN,MARV," & ¶ &
"MARY,MAE,MAMIE,MITZI,MOLLY,POLLY,MEL,MARIE,MARIANNE,MARIA,MARI,MARIBEL,MARIDETH,MEREDITH,MERADITH,MEREDITH,MARI,MERIDETH,MARYBETH,MARISET," & ¶ &
"MARIE,MARYBETH,MARY,BETH,BETTY,ANNEMARIE,ANNE,MARY," & ¶ &
"MATILDA,MATTY,MAUD,TILLY," & ¶ &
"MATTHEW,MATT,MATTIE,MATTY,MATTHIAS,THIAS,THYS," & ¶ &
"MAURICE,MOREY," & ¶ &
"MAUREEN,MARUEEN," & ¶ &
"MEADOWBRALY,MEADOW," & ¶ &
"MEHITABEL,HETTY,HITTY,MABEL,MITTY," & ¶ &
"MELINDA,LINDA,LINDY,LINDY,LYNN,MEL,MINDY," & ¶ &
"MELISSA,LISA,LISSA,MEL,MILLY,MISSY," & ¶ &
"MERVYN,MERV,MERVIN,MARVIN," & ¶ &
"MICHAEL,MICAH,MICK,MICKY,MIKE,MICKAEL,MICHEAL,MICHAELA,MICAELA," & ¶ &
"MILDRED,MILLY," & ¶ &
"MILLICENT,MILLY,MISSY," & ¶ &
"MINERVA,MINNIE," & ¶ &
"MIRANDA,MANDY,MIRA,RANDY," & ¶ &
"MIRIAM,MIMI,MITZI," & ¶ &
"MITCHELL,MITCH," & ¶ &
"MONTGOMERY,GUM,MONTY," & ¶ &
"MORRIS,MOREY," & ¶ &
"MUHAMMAD,ALI," & ¶ &
"NADEZDA,NADIA," & ¶ &
"NANCY,ANN,NAN,NAN," & ¶ &
"NAPOLEON,LEON,NAP,NAPPY,LEO,LEONARD,LEONARDO," & ¶ &
"NATALIE,NATTY,NETTIE,NETTY,NANNETTE,NANETTE,NANETE,NANNETT," & ¶ &
"NATASHA,TASHA,NATTY,NAT,NATTIE," & ¶ &
"NATHAN,NATHANIEL,NAT,NATE,NATTY,THAN," & ¶ &
"NEHARIKA,NEHA," & ¶ &
"NICHOLAS,CLAAS,CLAES,NICK," & ¶ &
"NICOLE,NIKKI," & ¶ &
"NIOMI,NEOMI,NEOME,NIOMIE,NIOMY,NOEMI," & ¶ &
"NORBERT,BERT,NORBY," & ¶ &
"NORA,NORAH," & ¶ &
"OBADIAH,DIAH,DYER,OBED,OBIE," & ¶ &
"OLIVE,LIVIA,NOLLIE,OLLIE,OLIVIA," & ¶ &
"OLIVER,OLLIE," & ¶ &
"OSAIBUEKU,OSAI," & ¶ &
"OSWALD,OSSY,OZZY,WALDO," & ¶ &
"PAMELA,PAM," & ¶ &
"PARMELIA,AMELIA,MELIA,MILLY," & ¶ &
"PATIENCE,PAT,PATTY,PATRICIA,PAT,PATSY,PATTY,TRICIA,TRISH," & ¶ &
"PATRICK,PADDY,PAT,PATE,PATSY,PETER," & ¶ &
"PAULA,PAULINA,LINA,POLLY," & ¶ &
"PELEGRINE,PERRY," & ¶ &
"PENELOPE,PENNY," & ¶ &
"PERCIVAL,PERCY," & ¶ &
"PETER,PATE,PETE,PETERS," & ¶ &
"PHILETUS,LEET,PHIL,PHILIP,PHILLIP," & ¶ &
"PHILINDA,LINDA,LINDY,LYNN," & ¶ &
"PHILIP,PHILLIP,PHIL," & ¶ &  
"PRESCOTT,PRES,SCOTT,SCOTTY," & ¶ &
"PRISCILLA,CILLA,CISSY,PRISSY," & ¶ &
"PRUDENCE,PRUDY,PRUE," & ¶ &
"RACHEL,SHELLY,RACHEAL,RACHAEL,RACHELL,MICHELLE,MICKEY,SHELLEY,ROSHELLE,RASHELLE," & ¶ &
"RAFAELA,RAFA," & ¶ &
"RAGHAVENDER,RAGHAV,RAG,RAJ,RAGHAVENDRA,RAGHAVA,RAGHVA,VENDER,VANDER," & ¶ &
"RANDOLPH,DOLPH,RANDY," & ¶ &
"RAPHAEL,RALPH," & ¶ &
"RAYMOND,RAY,RUSTY,RUSS,RANDY," & ¶ &
"REBECCA,BECCA,BECK,BECKY,REBA," & ¶ &
"REGINA,GINA,REGGIE," & ¶ &
"REGINALD,NALDO,REG,REGGIE,RENNY," & ¶ &
"RELIEF,LEAFA," & ¶ &
"RENEE,RENÈE," & ¶ &
"REUBEN,RUBE," & ¶ &
"RIHANNON,RHIANNON,RHIANNA,ARRIANNA,ARIANNA," & ¶ &
"RICARDO,RICHARD,DICK,DICKIE,DICKON,DICKY,RICH,RICK,RICKY," & ¶ &
"ROBERT,BOB,BOBBY,DOB,DOBBIN,HOB,HOBKIN,ROB," & ¶ &
"ROBERTA,BERT,BERTIE,BIRDIE,BOBBIE,BOBBIE,ROBBIE," & ¶ &
"RODGER,ROGER,ROD,ROGE,RUPERT," & ¶ &
"BOBBY,HODGE,ROBBY,ROBIN," & ¶ &
"ROLAND,LANNY,ORLANDO,ROLLO,ROLLY,ROLANDO,RONALDO," & ¶ &
"RONALD,NALDO,RON,RONNY," & ¶ &
"ROSABEL,ROSABELLA,BELLE,ROSALINDA,ROSALYN,LINDA,ROSA,ROSE,ROZ,ROSEMARY,ROSEANN,ANN,ROSEANNA,ROSEANNE,ROSITA,ROSEY,ROSANNA,ROXANNA,ROXANNE,ANN,ROSE,ROXIE,ROSIE," & ¶ &
"ROWEEN,OWEN," & ¶ &
"RUDOLPH,RUDOLPHUS,DOLPH,OLPH,ROLF,RUDY," & ¶ &
"RUSSELL,RUSS,RUS,RUSTY," & ¶ &
"RUAIRI,RUAIRY," & ¶ &
"RYAN,RYANAIY," & ¶ &
"SABRINA,BRINA," & ¶ &
"SAM,SAMMY,SAMANTHA,SAMUEL," & ¶ &
"SAMANTHA,SAM,SAMMY," & ¶ &
"SAMUEL,SAM,SAMMY," & ¶ &
"SANDRA,CASSANDRA,SANDY," & ¶ &
"SARAH,SADIE,SALLY,SARA," & ¶ &
"SERENA,RENA," & ¶ &
"SEYMOUR,MOREY,SEE," & ¶ &
"SHAKU,SHAKUNTHALA," & ¶ &
"SHARON,SHARRON,SHARREN,SHEREEN,SHAREEN," & ¶ &
"SHAWNARAH,SHAWNA," & ¶ &
"SHELTON,SHEL,SHELLY,TONY," & ¶ &
"SHERIDAN,DAN,DANNY,SHER," & ¶ &
"SHIRLEY,LEE,SHERRY,SHIRL," & ¶ &
"SIDNEY,SID,SYD,SIDD,SIDDHARTH,SYDD," & ¶ &
"SILAS,SI," & ¶ &
"SIMEON,SIMON,SI,SION," & ¶ &
"SKIP,SKIPP,SKIPPY,SKIPPER," & ¶ &
"SMITH,SMITTY," & ¶ &
"SOLOMON,SAL,SALMON,SAUL,SOL,SOLLY,ZOLLY,SELEMUN," & ¶ &
"SOPHIA,SOPHIE," & ¶ &
"STACEY,ANASTASIA,STACE,STACY,ACE" & ¶ &
"STEPHAN,STEVE,STEVEN,STEPHEN,STEPH,STEVE,STEPHAN,STEFFAN,STEVEN,STEPH,STEVE,SHEPHAN,STEFFAN,STEFAN," & ¶ &
"STUART,STU," & ¶ &
"SUBMIT,MITTY," & ¶ &
"SUDIENDRA,SUDHIE," & ¶ &
"SULLIVAN,SULLY,VAN," & ¶ &
"SUSAN,HANNAH,SUE,SUKEY,SUSIE,SUZIE,SUSANNAH,SUZI,SUZANNE,SUZZANNE,SUZAN,SUSANNAH,SUSANNA," & ¶ &
"SYLVESTER,SI,SLY,SY,SYL,VESSIE,VESTER,VET," & ¶ &
"TABITHA,TABBY," & ¶ &
"TAMMY,TAMMIE,TAMMI,TAMIE,TAMI," & ¶ &
"TANUJ,TJ," & ¶ &
"TERRY,TERESA,TERENCE," & ¶ &
"THADDEUS,THAD," & ¶ &
"THEODORE,TED,TEDDY,THEO," & ¶ &
"THERESA,TERRY,TESS,TESSA,TESSIE,THIRZA,THURSA,TRACY," & ¶ &
"THOM,THOMAS,THOM,TOM,TOMMY," & ¶ &
"TIGI,TIGIST,TIGGER,TIGER,TI," & ¶ &
"TIMOTHY,TIM,TIMMY," & ¶ &
"TOBIAS,BIAS,TOBY," & ¶ &
"TRAVIS,TRAIVS,TREVOR," & ¶ &
"TRYPHENA,PHENA," & ¶ &
"URIAH,RIAH," & ¶ &
"VADIL,VADIM," & ¶ &
"VALENTINE,FELTY," & ¶ &
"VALERI,VALERIE,VAL," & ¶ &
"VANESSA,ESSA,NESSA,VANNA," & ¶ &
"VERONICA,FRANKY,FRONY,RON,RONIE,RONNA,RONNIE,RONNIE,VONNIE," & ¶ &
"VICTOR,VIC," & ¶ &
"VICTORIA,TORIE,TORY,VIC,VICKI,VICKY,VICKIE," & ¶ &
"VINCENT,VIC,VIN,VINCE,VINCENZO,VINNIE,VINNY," & ¶ &
"VINSON,VINNY,VINCE,VINCENT," & ¶ &
"VIRGINIA,GINGER,GINNY,JANE,JENNIE,VIRGY,GINGI,GINNA," & ¶ &
"WALLACE,WALLY,WALT,WALTER,WALLY,WALT," & ¶ &
"WASHINGTON,WASH," & ¶ &
"WILBER,BERT,WILL," & ¶ &
"WILBUR,WILLIE,WILLY,WILL," & ¶ &
"WILFRED,FRED,WILL,WILLIE," & ¶ &
"WILHELMINA,MINA,MINNIE,WILLIE,WILMA," & ¶ &
"WILL,FRED,WILFRED,WILLIAM,BELA,BELL,BILL,BILLY,WILLIE,WILLY,WILSON,WILS,WILLIS,WILLI,WIL," & ¶ &
"WINFIELD,FIELD,WIN,WINNY," & ¶ &
"WINIFRED,WINNET,WINNIFRED,FRED,FREDDIE,FREDDY,WINNIE,WINNY," & ¶ &
"WYNTER,WINTER," & ¶ &
"WOODROW,DREW,WOOD,WOODY," & ¶ &
"YVONNE,VONNA," & ¶ &
"ZACHARIAH,ZACH,ZACHY,ZEK,E" & ¶ &
"ZEBEDEE,ZEB," & ¶ &
"ZEDEDIAH,DIAH,DYER,ZED," & ¶ &
"ZEPHANIAH,ZEPH," & ¶ &
//ACRONYMS:
"CJ,CAMERON,CHAD,CHRIS,CHRISTOPHER," & ¶ &
"AJ,ALEX,ALEXANDRA,ALEXANDER," & ¶ &
"";

listNumName = Position ( List; ¶ & Name1 & ","; 1; 1 );
listNumNicknames = Position ( List; "," & Name1 & ","; 1; 1 );
rowNumName = PatternCount ( Left ( List ; ListNumName ) ; ¶ ) + 1;
rowNumNicknames = PatternCount ( Left ( List ; ListNumNicknames ) ; ¶ ) + 1;

ListNames = Substitute( GetValue ( List; rowNumName ); ","; ¶ ) ;
ListNicknames = Substitute( GetValue ( List; rowNumNicknames ); ","; ¶ ) ;

ListMatchNames = UniqueValues (
			    Case( IsEmpty( ListNames) and IsEmpty( ListNicknames ); Name1; 
                                      IsEmpty( ListNames); ListNicknames; ListNames
                                    ) )
]; 
Case(ShowMatchValues; SortValues( ListMatchNames ); 
        ValueCount ( FilterValues ( ListMatchNames; Upper( Name2 ) ) ))

)
PURPOSE: Help to eliminate duplicative client records, provides another level of matching after email, phone number, & birthday
NOTES: Function will try to match with the first name of each row first (name), if no found matches, it will try matching with a nickname/alternative name.
If still no match is found, it will use the given Name1 and try to match it with Name2
Name1 is the source name, Name2 is the name you're trying to match it with. The result is boolean.
If you would like to see what names it is returning from Name1, enter a 1 for "ShowMatchValues" (useful for troubleshooting)
Comments

		Kyle Williams, Augusto Digital Sep 1, 2019
If you have any names or alternative names I'm missing, please post them so I can add them to this function, Thank you for your help :)
		Kyle Williams, Augusto Digital Jan 6, 2023
David Angel was nice enough to offer some suggestions such as "DAAVID" and "DAVIDS" as possibilities for the name "DAVID"... Thanks David!
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.
MatchFirstName ( Name1, Name2, ShowMatchList )

Comments

Support this website.

Support this website.
