Function request – ignore embedded return chars in CSV export

  • Resolved ascdev

    (@ascdev)


    4 years, 1 month ago

    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 4 years, 1 month ago by ascdev.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Javier Carazo

    (@carazo)

    @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

    (@ascdev)

    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

    (@carazo)

    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.