easyCIMB · text
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.
Schema
▸transactions
| id | INT |
| reference | TEXT |
Example input
▸transactions
Stuck? Ask the coach for a nudge that won't give the answer away, or reveal the reference solution and a short walkthrough of why it works.