HR FTE Input
Correct Manager Name Format
Worker's Manager
ParseComplex
Warn
Employee ID_Matched
Parse:
^(\w+)\W?((?<=\W).+(?=\W))?...
Manager = REGEX_Replace([Mgr Last Name]+', '+[Mgr First Name], '^,|,$|,(?=,)', '...
Sue Ellen Smith
Jones, Anna
Bob Smith
Jones, Robert A
Joe Smith [C]
Jones, William
Scott Smith
Jones, Sarah Lynn
Sarah Smith-Scott
Jones, Frank
Jane Frances Smith [C]
Jones, Edward
C:\Users\LIDWL51\AppData\Local\Temp\Engine_20624_bcdbc1d5cfe344d6ad96166ca9904815_\Engine_22380_929ee4fd79114a9c8f6a1caa5b5e13b1_.yxdb
Single
Profile
Correct Worker Name Format
Name
ParseComplex
Warn
Candidate Name_Matched
Parse:
^(\w+),\s(\w+)\s*(\w+)*
Horizontal
Manager-Worker Name Parse