I am working with a JSON dataset and need to extract specific values based on a condition using regex. I need to select values for Title parameter after 2000 year (including). My JSON data below…
{
"Data": {
"Items": [
{
"Start": "2018-04-05T05:00:00Z",
"End": "2018-04-05T05:30:00Z",
"Title": "Indiana Jones and the Raiders of the Lost Ark",
"Staff": {"Director": "Steven Spielberg", "Starring": "Harrison Ford"},
"TimeZone": "UTC",
"Id": "6ec29f07-c845-4967-9c87-716825265312",
"Year": 1981,
"IsNew": false,
"ReadOnly": true
},
{
"Start": "2018-06-29T12:00:00Z",
"End": "2018-06-29T12:30:00Z",
"Title": "The Lion King",
"Staff": {"Director": "Roger Allers", "Starring": "James Earl Jones"},
"TimeZone": "UTC",
"Id": "9d54f04d-3554-4b61-8077-0cfb79cb86db",
"Year": 1994,
"IsNew": false,
"ReadOnly": true
},
{
"Start": "2018-04-27T07:00:00Z",
"End": "2018-04-27T07:30:00Z",
"Title": "Avengers: Infinity War",
"Staff": {"Director": "Anthony Russo", "Starring": "Robert Downey Jr."},
"TimeZone": "UTC",
"Id": "425b2969-8ec0-4943-93ce-c5a1aec148b0",
"Year": 2018,
"IsNew": true,
"ReadOnly": true
},
{
"Start": "2018-04-27T07:00:00Z",
"End": "2018-04-27T07:30:00Z",
"Title": "Ready Player One",
"Staff": {"Director": "Steven Spielberg", "Starring": "Tye Sheridan"},
"TimeZone": "UTC",
"Id": "425b2969-8ec0-4943-93ce-c5a1aec148b0",
"Year": 2018,
"IsNew": true,
"ReadOnly": false
}
],
"From": 0,
"Portion": 0,
"TotalCount": 0
},
"RedirectViewModel": null,
"ExceptionViewModel": null
}
I tried “Title”:”[^”]+”,(?=.*”Year”:(200[1-9]|20[1-4])) this way.