https://legacy.forums.gravityhelp.com/topic/returns-in-textarea-causing-problems-in-csv-export Gravity Support Forums Topic: Returns in Textarea causing problems in csv export en-US Sun, 19 Apr 2026 18:20:25 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/returns-in-textarea-causing-problems-in-csv-export#post-272918 Fri, 24 May 2013 07:12:36 +0000 post@smart-media.no 272918@https://legacy.forums.gravityhelp.com/ <p>Hi,<br /> You can remove the returns before the data is saved to the database with the following script:</p> <pre><code>add_filter(&quot;gform_save_field_value&quot;, &quot;save_field_value&quot;, 10, 4); function save_field_value($value, $lead, $field, $form){ $new_value = str_replace(array(&quot;\n&quot;, &quot;\t&quot;, &quot;\r&quot;), &#39;&#39;, $value); return $new_value; }</code></pre> <p>\n removes new lines<br /> \t removes tabs<br /> \r remove carriage returns </p> https://legacy.forums.gravityhelp.com/topic/returns-in-textarea-causing-problems-in-csv-export#post-254514 Wed, 15 May 2013 20:16:00 +0000 ScottSendraDesign 254514@https://legacy.forums.gravityhelp.com/ <p>I am having an issue when I import Gravity Forms csv forms into Excel. The form I created uses multiple textarea fields. If a return is entered into a textarea, i.e more than one paragraph is added, when I import the csv data into Excel, the return is interpreted as a line break. This messes up my columns quite a bit!</p> <p>Is there a way of filtering for returns and replacing or deleting them? Or a way of preventing certain characters from being allowed in a textarea field?</p> <p>Thank you! </p>