I am having an issue with Response Export Automation - Daily export as CSV file. There is an open-ended/text entry question in the survey and people have commas and insert line breaks in their text entry responses. When the file exports and then is loaded into our database, it creates additional separate rows/records. I really only need completion date and externaldatareference fields - but because I can't specify which fields to export in Automation Export, trying to figure out work-arounds... are there custom rules or coding i can add to survey to remove characters from data? Should I be using a different export format?
Solved
Remove special characters & linebreaks in text entry data (Response Export Automation export issue)
+1Best answer by Radam
I've also ran into issues with various different encoding formats with CSV, might be worth looking into that too.
+33TSV (Tab separated) will solve your comma problem
JSON is probably the best because it really doesn't care what the data is or isn't.
+1I'm starting wonder if the line breaks that are causing the issue, because there's plenty of commas in other participants' comments but not sure why some people's write-in data breaks off into new rows (not into new columns). could it potentially be issue with file processing settings on my team's side?
+33I've also ran into issues with various different encoding formats with CSV, might be worth looking into that too.
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.