Regex working in mongo but not using java

Question

This Regex is working in mongo query as below :

{$match : {'file_details.tec_stop' : {$regex : /(\d\|){1}\d/}}},

but now working when using java :

String stopRegex="/(\\d\\|){"+stops+"}\\d/";
pipeline.add(new BasicDBObject("$match", new BasicDBObject("file_details.tec_stop'", new BasicDBObject("$regex", stopRegex))));

What's the issue?

You don't delimit a Java regex within a String using '/'. That would be redundant. — laune
– laune, Commented Mar 24, 2017 at 7:36
I'd also call Pattern.quote(stops) and use the result in stopRegex. — laune
– laune, Commented Mar 24, 2017 at 7:39

Trash Can · Accepted Answer · 2017-03-24 07:37:13Z

1

You need to remove the first / and the last / from your Java regex. They are Javascript specific regex literal which is the language used by mongodb shell

Javascript RegExp

answered Mar 24, 2017 at 7:37

Trash Can

6,8325 gold badges27 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

munish Over a year ago

Na it's still not working either. I have a string like 1|0|2 and I am trying to match it with below reqular expression in java ^(\d\|){2}\d$

Trash Can Over a year ago

Collectives™ on Stack Overflow

Regex working in mongo but not using java

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related