Hello,
My survey currently has a form question that asks respondents for their City and State. The state question has the US State validation setting selected.
I store respondents' answers to the state Q as Embedded Data (see the last row):

On the next page, I ask respondents how many years they have lived in their state (using the embedded data labels).
"About how many years have you lived in ${q://QID678/ChoiceTextEntryValue/2}?"
This works fine, but it displays the state exactly as the respondent worded it (e.g., About how many years have you lived in ca?")
My problem: I would like to display the properly capitalized, full name of the state in the second question. So, for example, if the respondent enters "ca", I would like the second question to ask "How long have you lived in California?" (A less ideal but acceptable solution would convert "ca" to "CA".) I also don't want to have to use an external dataset to do this, if possible.
I understand that I can do this if I ask respondents for their zip code (see link), but I don't know how to simply clean up the state abbreviation respondents have already entered.

Any help would be very much appreciated! Thanks.