JsonPath expression to filter using regex

Question

We are using a tool which uses jayway library for evaluating JSONpath expression. Javascript does NOT seem to work with it. How can I use regular expression in the JSONPath in such a case. For instance, in the below example I would like to filter all book titles whose title has the word "Sword" in it:

{
    "store": {
        "book": [
            {
                "category": "reference",
                "author": "Nigel Rees",
                "title": "Sayings of the Century",
                "price": 8.95
            },
            {
                "category": "fiction",
                "author": "Evelyn Waugh",
                "title": "Sword of Honour",
                "price": 12.99
            },
            {
                "category": "fiction",
                "author": "Herman Melville",
                "title": "Moby Dick",
                "isbn": "0-553-21311-3",
                "price": 8.99
            },
            {
                "category": "fiction",
                "author": "J. R. R. Tolkien",
                "title": "The Lord of the Rings",
                "isbn": "0-395-19395-8",
                "price": 22.99
            }
        ],
        "bicycle": {
            "color": "red",
            "price": 19.95
        }
    },
    "expensive": 10
}

I would find a workaround instead of trying to use regular expression. — hwnd
– hwnd, Commented Mar 10, 2015 at 1:33

kalle · Accepted Answer · 2015-03-10 12:03:34Z

19

The Jayway implementation uses the Ruby regex operator:

$.store.book[?(@.title =~ /^.*Sword.*$/)]

To ignore case:

$.store.book[?(@.title =~ /^.*sword.*$/i)]

answered Mar 10, 2015 at 12:03

kalle

1,91914 silver badges14 bronze badges

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

3 Comments

sjn Over a year ago

I tried the above expression with json-path-0.9.0 in the classpath (as the tool uses the version 0.9 internally) and the statement Object result = JsonPath.read(jsonStr, query); where jsonStr is the one shared in the example above. The result is an empty set

kalle Over a year ago

Regex support was added in 1.2.0.

karthikeyan Over a year ago

Nice. If I want to get values of all keys that startswith title, How would I go about writing it?

JPA · Accepted Answer · 2020-01-09 09:48:33Z

2

For the record, a workaround for conditional regex in Goessner's javascript JSONpath would be to write the query as follow:

$.store.book[?(/^.*sword.*$/i.test(@.title))]

Please see here https://github.com/jpaquit/jsonpath/tree/0.8.5-+-regexp for "=~" syntax in JS lib.

answered Jan 9, 2020 at 9:48

JPA

211 bronze badge

2 Comments

bviktor Over a year ago

Any clues as to what i.test is? :D

JPA Over a year ago

@bviktor "i" is the regex flag for "case-insensitive" and "test" is the dedicated JS function ;) developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/…

Avinash Raj · Accepted Answer · 2015-03-10 01:31:05Z

0

You could use capturing group or lookbehind assertion.

"title":\s*"([^"]*\bSword\b[^"]*)"

Add case-insensitive modifier i if necessary. Grab the title string from group index 1.

DEMO

answered Mar 10, 2015 at 1:31

Avinash Raj

175k32 gold badges247 silver badges289 bronze badges

Collectives™ on Stack Overflow

JsonPath expression to filter using regex

3 Answers 3

3 Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related