How to reformat embedded data which contains quotation marks.

Question

Hi,I have a survey with a ‘lab.js’ screen included in it. The results from that screen are extracted and stored in a Qualtrics Embedded data field. When I view the results within Qualtrics I can see that all the ‘lab.js’ data is there but concatenated into a single cell. When it is downloaded some of this data has been truncated. I have tried to reformat this data within Qualtrics using Piped data and Javascript. I think that because it includes numerous quotation marks the Javascript is getting confused and my Javascript variables do not get populated when I try to copy the embedded data into them. I have tested that I am able to display the whole concatenation within an HTML  tag on a later question screen, so I know the Piped data is accessing the right field. I am only interested in a few items at the end of the concatenated embedded data that are missing from the truncated downloaded field. Is it possible to increase the size of the downloaded embedded data? If not, is it possible to copy and reformat into smaller embedded data fields via Javascript some selected parts of the data from the original concatenation that could then be downloaded in a more user-friendly format?

preichow · Accepted Answer

For the benefit of others who might find this question since it was originally posted:Single and Double Quotation marks can cause issues in many systems and languages because they are usually reserved for system use.If you want to use them, you have to add anescape character.If you ever run into something like this, try each of the following. If a step doesn’t work, be sure to remove it and move to the next.In Javascript:By placing abackslash (`\`)before a quote, you can ensure that the quote is treated as part of the string rather than as a delimiter.In HTML, the escape character for a quote (double quotation mark) is"&quot;".Explanation:"&quot;":Represents a double quote character."&apos;":Represents a single quote or apostrophe character.In most database systems, the escape character for quotes is abackslash (\), meaning you would put a backslash before a quote to indicate that the quote should be interpreted literally within a string.Key points about escaping quotes in databases:Common syntax:To escape a single quote, use', and to escape a double quote, use\".Example:To store the string "O'Neill" in a database, you would write it as'O''Neill'.

ahmedA · Answer

Please see this discussion: https://www.qualtrics.com/community/discussion/comment/35885https://www.qualtrics.com/community/discussion/comment/35885#Comment_35885And raise an issue with Qualtrics sp that they do something about it.

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded