Manipulate strings in mongodb that match the regex search

Question

In java this is possible

public static void main(String[] args) {
    Matcher m = Pattern .compile("^(.*?[.].*?[.].*?[.].*?)[.].*")
                        .matcher(
                                "com.SEM.Google.Generico.space.test");
    if (m.matches()) {
        System.out.println(m.group(1));
    }
}

This would give me as result: com.SEM.Google.Generico

If I have a string in mongodb

"dv" : "com.SEM.Google.Generico.space.test"

can I use the mongo aggregation framework somehow to get com.SEM.Google.Generico as result?

It should be as generic as possible. So not something like

$project: {
    pathString: {
        $substr: ["$path.dv", 0, 23]
    }

}

Is this possible at all? Thanks.

felix · Accepted Answer · 2016-10-27 18:29:56Z

2

No, there is no way to do this.

This feature has been requested two years ago, but it hasn't been implemented yet ( see the open jira issue: https://jira.mongodb.org/browse/SERVER-11947 ). If you don't want to use $substr I guess that you should apply the regex on the query results...

answered Oct 27, 2016 at 18:29

felix

9,3158 gold badges44 silver badges65 bronze badges

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

Comments

satish chennupati · Accepted Answer · 2016-10-27 18:23:42Z

0

var pattern = "Your Regex Pattern"
db.yourCollectionName.find( { "dv": { $regex: pattern} } )

should produce the desired results

answered Oct 27, 2016 at 18:23

satish chennupati

2,6601 gold badge21 silver badges27 bronze badges

Collectives™ on Stack Overflow

Manipulate strings in mongodb that match the regex search

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related