left/right substring extraction functions from piped text?

Question

I have a drill-down question, the third tier of which is populated with choices that all follow the same format: "(9-digit ID) - (person's name)". I can base piped text off of this subquestion just fine, but I am looking to have a modified piped text to put into an embedded data field that only captures the first 9 characters of the string for any of the possible choices (i.e. I only want the ID to be piped into the embedded data field from the selected choice).

Is there a way to mimic a LEFT(string, 9) function from excel in the survey flow to get that substring extracted correctly?

fleb · Accepted Answer

You can do this using following JavaScript:    Qualtrics.SurveyEngine.addOnload(function()    {    var a = "${q://QID28/ChoiceGroup/SelectedChoices}".substring(0,9);     Qualtrics.SurveyEngine.setEmbeddedData("a", a);    })(I found that here.)Note: The code must be executed after submitting the page with the question. (You can do it earlier, but then you can't use piped text).Note 2: Your embedded data field must be defined in the survey flow.

JonathonJames · Answer

@fleb thank you so much for your help, that worked beautifully!

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded