Display Parent Manager First Name and Last Name in 2 separate columns

Content

Hello,

I have an analysis I am creating that the end user has requested manager first name and last name to be in 2 separate columns. I have referenced this post (https://cloudcustomerconnect.oracle.com/posts/b1c5acfce0) to get manager first name last name in that order in the same column, but I cannot figure out how to separate first and last name into 2 columns. I am using Parent Manager 01, so my current function is:

CONCAT(CONCAT(SUBSTRING("Parent Managers"."Parent Manager 01 Name" FROM LOCATE(',',"Parent Managers"."Parent Manager 01 Name")+1 FOR LENGTH("Parent Managers"."Parent Manager 01 Name")), ' '), SUBSTRING("Parent Managers"."Parent Manager 01 Name" FROM 0 FOR LOCATE(',', "Parent Managers"."Parent Manager 01 Name")-1))