How to define delimeter to import mongodb

Question

I have a data collection, which is separated by | character. I am going to add the data collection to mongodb. So I need to separate data through | character. how my mongoimport command looks like?

Previously, I'm successfully import csv file through the following command.

$ mongoimport -d mydb -c things --type csv --file locations.csv --headerline

Yahiya

mongoimport can handle json, csv and tsv. You need to convert this file into csv or tsv format. – Pigtail

ok, if we convert to the csv file, how can I separate fields with '|' pipeline character – Yahiya

"csv" = comma separated. – Pigtail

Can't we use csv file to separate with '|', or it is only able to separate with ',' – Yahiya

By definition, the "c" in csv stands for "comma". – Pigtail

Answer 1

mongoimport supports either JSON, CSV (comma separated values) or TSV (tab separated values). The | character is not a valid delimiter for either CSV or TSV, so you will need to change your input files' | to , or a tab, and specify --type accordingly.

Sortition

Answer 2

mongodb could actually treat a | seperated record in a .unl, .txt, .csv

Just make sure you do this in the format below. For the specified mentioned extensions use the --type csv:

mongoimport -c <table_name> -d <database_name> --mode upsert --file <filename> --type csv --headerline

Vendor