Title: Carriage Returns
Last modified: August 22, 2016

---

# Carriage Returns

 *  Resolved [provdes](https://wordpress.org/support/users/provdes/)
 * (@provdes)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/carriage-returns/)
 * I am trying to import a large csv which has one field that will be going into
   a text area on the site. The field contains postal addresses as one block, but
   90% of these addresses have carriage returns (line breaks) within them. Eg:
 * House Name
    Street Name City County Post Code
 * When importing using your plugin any rows that have addresses that have been 
   written like this are not imported.
 * Is there a fix for this, other than editing the line breaks out of the entire
   csv?
 * [https://wordpress.org/plugins/import-users-from-csv-with-meta/](https://wordpress.org/plugins/import-users-from-csv-with-meta/)

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/)
 * (@carazo)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/carriage-returns/#post-5542417)
 * provdes,
 * Good morning, this is a bug of the plugin. The plugin is not prepared to read\
   n or \r or \n\r inside fields because the parsr firstly breaks the file in lines.
 * In CODECTION we have no time to fix it (it would need a complete code change),
   the only way is that some support this develop.
 * If you want or any other tell me.
 *  Thread Starter [provdes](https://wordpress.org/support/users/provdes/)
 * (@provdes)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/carriage-returns/#post-5542520)
 * Awww man – that is such a shame!!
 * I have so many users to import and so many line breaks to remove.
 * For anyone else with the same issue, the only work around we have is to manipulate
   the csv in Excel and remove the line breaks using either formula or macro.
 * Details on how were in this very useful page:
 * [https://www.ablebits.com/office-addins-blog/2013/12/03/remove-carriage-returns-excel/](https://www.ablebits.com/office-addins-blog/2013/12/03/remove-carriage-returns-excel/)

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Carriage Returns’ is closed to new replies.

 * ![](https://ps.w.org/import-users-from-csv-with-meta/assets/icon-256x256.png?
   rev=1174343)
 * [Import and export users and customers](https://wordpress.org/plugins/import-users-from-csv-with-meta/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/import-users-from-csv-with-meta/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/)
 * [Active Topics](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/reviews/)

## Tags

 * [carriage returns](https://wordpress.org/support/topic-tag/carriage-returns/)
 * [line breaks](https://wordpress.org/support/topic-tag/line-breaks/)
 * [users](https://wordpress.org/support/topic-tag/users/)

 * 2 replies
 * 2 participants
 * Last reply from: [provdes](https://wordpress.org/support/users/provdes/)
 * Last activity: [11 years, 8 months ago](https://wordpress.org/support/topic/carriage-returns/#post-5542520)
 * Status: resolved