I have a variable that captures actual household address, say, "76 Longstreet Albertville Gauteng". I want to generate another variable (string) that captures the province that the household is located in this case Gauteng. The text is case variaed (i.e. there are caps and lower cases for the address).