Hi all! I have embedded data that is coming over from a vendor (using the URL embedded process). It comes in one long string of data. I need this data parsed out to use in the dashboards as filters or widgets. Here is an example: Z-ABCD-89_new_associate_sno_8-30-2023 This is the response I have when a user takes a survey. I need 4 different columns of data from this response. Using the example above here are the 4 different data columns needed - All separated by “_” (although the course name may cause issues as it underscores spaces in the name) “Z-ABCD-89” is the course id “new associate” is the course name “sno” is the site / location “8-30-2023” is the Cohort DateHow can I parse this out? I have tried looking at other posts, but they seem a bit different than what I need. A lot of solutions are JavaScript (which I’m not too familiar with but can try and figure out). Any suggestions on how I can get this data parsed out after it’s passed over in a survey embedded field? Any help you can provide will be greatly appreciated! Thanks in advance for your time!

@AMLS,You’ll need to use JS.First, define the embedded data fields in thesurvey flow: classId, courseName, location, cohortDate.Then JS attached to a question(Assuming nounderscores in course name. Underscores in course name could be handled, but it would be much more complex):Qualtrics.SurveyEngine.addOnload(function() { var fields = ["classId", "courseName", "location", "cohortDate"]; var vals = "${e://Field/vendorString}".split("_"); //replace vendorString with correct name jQuery.each("fields", function(i,name) { Qualtrics.SurveyEngine.setEmbeddedData(name, vals[i]); )};});

Parsing/Separating URL Embedded Data Format

Parsing/Separating URL Embedded Data Format | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded