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
- duplicates
-
SERVER-1097 mongoimport / export should adhere to CSV spec
- Closed