Update record with parsed reference value for projects

Your project table has compound reference strings that break routing and downstream reports. It extracts a canonical reference and writes it back so project managers have normalized IDs same day.

Overview

Inconsistent reference strings make routing and reports unreliable and force manual fixes from project managers. This workflow extracts a canonical identifier and writes it back to the record, so coordinators can route work and produce accurate reports same day.