I have a text area in a form field where a user can send a message. This is on one form on one page. However, I am getting inconsistent outputs in the CSV where some message will be enclosed in quotes, and some will not. How can I ensure this consistently outputs data without the quotes?
The issue with inconsistent quotes in your CSV export likely stems from how the form submissions are handled and how special characters (like commas, newlines, or double quotes) are present in some messages. CSV format rules dictate that fields containing such characters must be enclosed in quotes to avoid breaking the structure of the file.
Thank you for that information. I still need consistency in the output, either all enclosed in double quotes or stripped. I can use something apps script to strip them, but it complicates the workflow and would prefer a direct line from Webflow’s output. Any thoughts?
Webflow is exporting as CSV. If you need to modify that for some reason, and create a “variant” of CSV where all fields are delimited with double-quotes, you’d need to build some post-processing to do that.
Perl / python scripts are good for that kind of thing.