Parse a Race Field Into 5 Separate Fields
Posted on 2011-05-11
I have a Race Code Field, which is a multiple choice drop-down field on a menu. This Race Code field is storead as the following: 1&2&3&4&5. 1=White/Caucasian; 2=Black/African American; 3=American Indian/Alaska Native; 4=Asian; 5=Native Hawaiian/Other Pacific Islander. What I need to do, is separate this field into 5 separate fields and I need to enter the actual value of this field into the new fields, not the code itself. Also, the catch is, that not all 5 races are selected everytime and they could be a combination of the numbered sequence above.