Hello,
I am trying to work out how to remove hyperlinks when data gets exported to an excel spreadsheet through a workflow to no avail. The question has answers that are hyperlinked to a website to provide more information and the workflow is set to yield ${q://QID31/ChoiceGroup/SelectedChoices}. When the workflow runs, it provides me with the following:
Title
How can I get the "href" and "target" removed so that it just gives me the "Title" in the spreadsheet?
Thank you so much for your consideration!
Removing Hyperlinks during Excel Workflow
+2
+46https://community.qualtrics.com/XMcommunity/discussion/23557/removing-hyperlinks-during-excel-workflowIf it's just one question you can make those options in the survey flow as embedded data and based on what is selected (branch logic) you can pipe the embedded data in the workflow. It will give you the hardcoded value.
Hope it helps!
+2Hi Deepak,
It is just one question, but the question allow for multiple answers and there are quite a few. Is embedding the data and piping in the Excel output still the best option here?
Thank you!
+46https://community.qualtrics.com/XMcommunity/discussion/comment/54049#Comment_54049The more easier way would be to do with JS you can create just one empty embedded data and strip the html from the entire text and push it in the embedded data. Then use that as piped text.
Hope it helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.