Issue Adding Data with Special Characters to a Table
I'm building a webform questionnaire where I populate the answers to questions in a table, convert the table to excel and markdown, then email the markdown table and the excel attachment in an email.
I'm having issues populating the table when the answers to the questions include special characters, specifically if the response includes quotation marks ("sample info") within the response.
According to the help text for the 'Values' field, "If the value contains quotation marks, they must be escaped with a quotation mark."
I've tried wrapping the value in single and double double quotes (""sample info"", "sample info") but I can't seem to get the process to add info to the table when the value includes quotation marks.
Any help is appreciated.