1) use public access code to replace original value
2) use state full name to replace original state abbreviation code