I have an attribute table with two types of text fields (34 of each). One type attributes an "r" or a "d" for each feature. These fields represent the voting results in either presidential or gubernatorial elections of each county for each election year from 1948 to 2014. These fields are called prez48, gov50, prez52, gov54, etc. The second set of fields have "_lng" appended to them (prez48_lng, gov50_lng, etc.) These fields have no data in them yet.
I would like to automate the process of calculating this second set of fields to turn "r" (from the first set) into "Republican" and "d" into "Democrat". Example: if prez48 = "r" then prez48_lng = "Republican".
Can this be done without coding?