export to excel; one field to multiple rows
Hello, When I attempt to export a report the result is it has the correct column names and initial data but one of the fields for a few records is getting put at the bottom in the first column unde...
Forum Discussion
Most likely, it's a problem with the text being inserted and how Excel is interpreting the CSV data - namely the column delimiters. I'm guessing your weird column break issue occurs when the user has entered a comma into the text field. Unfortunately, I don't know of a reliable way to fix that except to strip any commas from the text using a formula and then downloading from a report that uses the formula instead of the original text.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------