This is just one employee in one raw, I have whole column with all names like this and need to clean up different scenarions
HERNANDEZ JR, FELIX / BRADY, ANDEl
LAZARINI, JUAN
COLON, ANTHONY N
ROGERS, ALPHONSO D / GUZMAN-MARTINEZ, PORFIRIO
DEJESUS, RUBEN R / REYES, CARLOS
anything after "/" are their supervisor name and can be removed in my new field. Output needs to be:
Felix Hernandez
Juan Lararini
Anthony colon
Alphonso Rogers
Ruben Dejesus