Menu

#378 Optional Text Delimiter for File Import

General
closed
nobody
medium
2020-04-01
2010-01-03
sfst
No

I have tab delimited files, where a blank between tabs really should be inserted as one blank (there are many NOT NULL columns)
I only could get the import to work when I double quoted the blanks (not only making the files larger and less readable, but also needed the additional step of getting the blanks quoted).

So I envision an option in the import dialog, where I can choose any Text Delimiter (even none).
Double quotation marks should be shown by default.

Remark: with Open Office' sCalc you can choose any Text Delimiter on export/import. With some limits this allows you preserving the quotation marks in your data.

Discussion

  • sfst

    sfst - 2010-05-20
    • priority: 5 --> 1

    -
    (I understand 1 is the lowest priority; as I have a work-around it isn't urgent)

     

    Last edit: sfst 2013-07-17
  • sfst

    sfst - 2020-03-27

    Thank you. Snapshot 2020-02-20 offers all functionality needed, so this request can be closed.

     
  • Gerd Wagner

    Gerd Wagner - 2020-04-01
    • status: open --> closed
    • Priority: 1 --> medium
     

Log in to post a comment.

MongoDB Logo MongoDB