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?
Best answer by Radam
View original