Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Thank you so much for the reply. I was able to separate first and last name using substring, left and right functions. SUBSTRING((TRIM(BOTH ' ' FROM (SUBSTRING("Manager"."Name" FROM (POSITION(' ' IN "Manager"."Name")) FOR 100)))) FROM (LOCATE(' ', (TRIM(BOTH ' ' FROM (SUBSTRING("Manager"."Name" FROM (POSITION(' ' IN…