Title: Function request – ignore embedded return chars in CSV export
Last modified: February 24, 2021

---

# Function request – ignore embedded return chars in CSV export

 *  Resolved [ascdev](https://wordpress.org/support/users/ascdev/)
 * (@ascdev)
 * [5 years, 3 months ago](https://wordpress.org/support/topic/function-request-ignore-return-char-in-csv-export/)
 * Some of my user’s data includes Return characters embedded in the data.
    When
   I export the data to a CSV file, this truncates the line entry for the user and
   puts the remaining data on a new line. A simple, albeit tedious workaround, is
   to edit the CSV file manually to remove the extraneous Returns.
 * It would be really nice if there was an option in Export settings to ignore Return
   characters embedded within field data.
    -  This topic was modified 5 years, 3 months ago by [ascdev](https://wordpress.org/support/users/ascdev/).

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

 *  Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/)
 * (@carazo)
 * [5 years, 3 months ago](https://wordpress.org/support/topic/function-request-ignore-return-char-in-csv-export/#post-14107288)
 * [@ascdev](https://wordpress.org/support/users/ascdev/),
 * Could you send me some CSV with this problem (remove all personal information).
   I have \n and \r or \r\n in metadata and I have no problems with any export.
 *  Thread Starter [ascdev](https://wordpress.org/support/users/ascdev/)
 * (@ascdev)
 * [5 years, 3 months ago](https://wordpress.org/support/topic/function-request-ignore-return-char-in-csv-export/#post-14121722)
 * Ah, this appears to be an issue with Excel.
 * If I use a regular comma separated file – Excel handles embedded return chars
   correctly. If I use an alternative delimiter – it breaks the lines at the return
   chars.
 * LibreOffice works just fine.
 * Many thanks for your time and clarification.
 *  Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/)
 * (@carazo)
 * [5 years, 3 months ago](https://wordpress.org/support/topic/function-request-ignore-return-char-in-csv-export/#post-14121790)
 * Yes, we are in Linux, and we cannot test it in MS Excel, anyway to manage CSV,
   LibreOffice is always a better option.

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

The topic ‘Function request – ignore embedded return chars in CSV export’ 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/)

 * 3 replies
 * 2 participants
 * Last reply from: [Javier Carazo](https://wordpress.org/support/users/carazo/)
 * Last activity: [5 years, 3 months ago](https://wordpress.org/support/topic/function-request-ignore-return-char-in-csv-export/#post-14121790)
 * Status: resolved