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

CSV/TSV import split data on line breaker

    • Type: Icon: Bug Bug
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 1.8.0
    • Component/s: Tools
    • Environment:
      window xp
    • Windows

      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

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

              Created:
              Updated:
              Resolved: