https://legacy.forums.gravityhelp.com/topic/issues-with-strange-character-where-user-used-a-carriage-return Gravity Support Forums Topic: Issues with strange character where user used a carriage return en-US Sun, 19 Apr 2026 18:40:11 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/issues-with-strange-character-where-user-used-a-carriage-return#post-72638 Sun, 26 Aug 2012 06:05:45 +0000 RealDesign 72638@https://legacy.forums.gravityhelp.com/ <p>Thank-you ... I will see if I can get the customer to get it to work!</p> <p>Much appreciated </p> https://legacy.forums.gravityhelp.com/topic/issues-with-strange-character-where-user-used-a-carriage-return#post-72626 Sun, 26 Aug 2012 02:13:25 +0000 Chris Hajer 72626@https://legacy.forums.gravityhelp.com/ <p>Normally, this is due to the encoding being used when the CSV is imported into Excel. I find that setting the character set to Unicode UTF-8 takes care of the strange characters in the CSV. I don't have a current version of Excel here to capture the dialog, but this is what it looks like in OpenOffice.org when importing a CSV. </p> <p><a href="http://minus.com/l2pmXVR2xqPcN" rel="nofollow">http://minus.com/l2pmXVR2xqPcN</a></p> <p>Note the first drop down, the Character Set. By default, that was Western Europe (ISO 8859-1) when I first ran the program. I think changing that will probably work for this problem. </p> https://legacy.forums.gravityhelp.com/topic/issues-with-strange-character-where-user-used-a-carriage-return#post-72138 Wed, 22 Aug 2012 14:17:40 +0000 RealDesign 72138@https://legacy.forums.gravityhelp.com/ <p>I have a form at : <a href="http://basketfullofrecipes.com/" rel="nofollow">http://basketfullofrecipes.com/</a><br /> Where the user is submitting recipes. We have some users who are using the "return" key inside the longer text boxes. When you export the csv file and then import it into excel, we find a "junk" character has been put where the carriage return is.</p> <p>I personally am not able to replicate this, it is my end user that is having the issue. They are using windows and a variety of excel versions including at least 2010 and 2003. However she has sent me a screen shot and I have seen the issue. When you look at the spreadsheet every thing looks fine until you highlight a cell with a carriage return in it and look in the formula bar ... then you see the funny character (it looks like a ? in a black diamond) </p> <p>Any ideas on how to eliminate this problem?</p> <p>Installation Status</p> <p>PHP Version 5.2.17<br /> MySQL Version 5.1.63<br /> WordPress Version 3.3.1<br /> Gravity Forms Version 1.6.5.1 </p>