For the new inserts, the committee name appears like this: BERNIE 2016 (C00577130) .
And the committee_id = 'NULL'
So in regex: [a-zA-Z0-9]*(C[0-9)] .
so now... when we insert the committee name.. we need to do a quick Regular expression string split..such that
the first part is under committee_name and the Cxxxxxxx part is under committee_id
For the new inserts, the committee name appears like this: BERNIE 2016 (C00577130) .
And the committee_id = 'NULL'
So in regex: [a-zA-Z0-9]*(C[0-9)] . so now... when we insert the committee name.. we need to do a quick Regular expression string split..such that the first part is under committee_name and the Cxxxxxxx part is under committee_id