CODEWITHSUNDEEP
regexjsonjsonpath
sjn
sjn

Reputation: 181

JsonPath expression to filter using regex

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
}

Upvotes: 16

Views: 52031

Answers (3)

JPA
JPA

Reputation: 21

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.

Upvotes: 2

kalle
kalle

Reputation: 1909

The Jayway implementation uses the Ruby regex operator:

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

To ignore case:

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

Upvotes: 19

Avinash Raj
Avinash Raj

Reputation: 174864

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

Upvotes: 0

Related Questions