Formula to get the second hierarchy of a multiple Parent-Child Subsidiary

Get the Parent 1 in a Parent: Parent1: Child 1 hierarchy of a subsidiary. Use the below formula:

rtrim(regexp_substr({subsidiary},'[^:]*$'))