@darklilcorner if you change the formula to just

UPPER(SUBSTR({entityid}, 1, 4))

do you see the expected result ('IR -', 'AU -' etc..)?