Pull the branch code out of a reference number

Every transaction reference follows the pattern CIMB-<date>-<branch code>, e.g. CIMB-20260512-KLCC. For each transaction, return id, reference, and branch_code — the text after the last hyphen.