get the text from one string

Not sure that works Martin

Best I can see at the moment is

=LEFT(SUBSTITUTE(SUBSTITUTE( A2,IF(LEFT(A2,6)="ZG_HU_","ZG_HU_","ZG_HA_"),""),"ECC_",""),FIND("_",SUBSTITUTE(SUBSTITUTE( A2,IF(LEFT(A2,6)="ZG_HU_","ZG_HU_","ZG_HA_"),""),"ECC_",""),1)-1)

Or to simplify use two columns
B2

=SUBSTITUTE(SUBSTITUTE( A2,IF(LEFT(A2,6)="ZG_HU_","ZG_HU_","ZG_HA_"),""),"ECC_","")

C2

=LEFT(B2,FIND("_",B2,1)-1)

But I'm pretty sure there will be more wobblies yet.

[EDIT]
Where the Check list shows FALSE the source string was changed for testing for errors.
And
Some of the business roles have more than 5 characters