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.
Question
How to display full state name using embedded data and content validation?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
