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!
Sign up
Already have an account? Login
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login to the Community
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.