Select a particular value from concatenated field

Summary:

To obtain a specific value from concatenated field.

The business requirement is to obtain information regarding people reporting to C suite (Senior Leadership) and people reporting to Senior Leadership (Senior Leadership minus 1 level).

Content (please ensure you mask any confidential information):

The below formula is used to create a singular field of all the parent manager. When we are running the below formula for each associate, the number of parent manager varies. We are looking for the fourth value from the formulated column to be returned to obtain Senior Leadership minus 1 level.

Is this the right approach? If yes, how to obtain the fourth value from the concatenated column?