Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-3180

CSV/TSV import split data on line breaker

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major - P3 Major - P3
    • None
    • 1.8.0
    • Tools
    • window xp
    • Windows

    Description

      when import data that contains long descritpion text, mongo import tool snap a single CSV cell and treat it as multiple line

      Sample Data

      TITLE , DESCRIPTION
      title 1 , " this is sample description, line break start here
      description continue on new line
      end of description here. "

      Excel will disaply above csv file correctly, however, because description contains line break, mongodb import tool will treat it as 3 csv records instead of a single cell.

      I think this is a bug and hope the fix can go into the latest release.

      Please also advise if here is any work around to allow successfully import the csv content and stop the record being truncated by line breaker.

      Regards,
      Charles

      Attachments

        Activity

          People

            mathias@mongodb.com Mathias Stearn
            ckeqiao Charles Ke Qiao
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: