mongoexport regex unnknown option

Question

mongoexport --db ucc_prod /host:myserver /port:27017 --username user1 --password password1 /query:'{copysheet: {$regex: "/^.*pdf/"}}' /out:copysheets.csv --type=csv --fields svOrderId,svItemId --collection copies

gives me error

2016-09-02T08:17:34.632-0500    error parsing command line options: unknown option "^.*pdf/}}'"

What syntax am I missing here?

Try `'{ "copysheet": { "$regex": "^.*pdf", "$options": "" }}'` — Wiktor Stribiżew, Sep 02 '16 at 13:55
I get the following error now: 2016-09-02T08:59:46.604-0500 too many positional arguments: [copysheet: { $regex: ^.*pdf, $options: }}'] — Prabhat, Sep 02 '16 at 14:00
See http://stackoverflow.com/a/13292572/3832970. Well, maybe you need to swap the quotation marks? `--query "{ 'copysheet': { '$regex': '^.*pdf', '$options':'' }}"` (especially if you are on Windows). — Wiktor Stribiżew, Sep 02 '16 at 14:06

score 7 · Accepted Answer · answered Sep 02 '16 at 17:05

7

You may use

--query "{ 'copysheet': { '$regex': '^.*pdf', '$options':'' }}"

The point is that you should pass the data to the query argument as JSON.

See reference:

--query <JSON>, -q <JSON>
Provides a JSON document as a query that optionally limits the documents returned in the export. Specify JSON in strict format.

Note: on different systems, you might need to swap single with double quotes.

answered Sep 02 '16 at 17:05

Wiktor Stribiżew

607,720
39
448
563

3

This answer is great! Just a bit more hint: In my case, mongoexport in Windows CMD forced me to wrap the query string with double quotes, then the remote Mongo server required me to wrap field names and strings with double quotes too. Eventually I had to escape the double quotes in the query in order for it to work. E.g., `--query "{\"fieldName\": {\"$regex\": \"search-string\", \"$options\": \"i\"}}"`. – Marty ZHANG Sep 15 '20 at 08:30

mongoexport regex unnknown option

1 Answers1