Return specific portion of a string in specific format that includes a number[]

I won’t lie, regex is definitely not a strength of mine so hoping to borrow the talent of someone whose it is.

What I need to do is from a string that would look something like this;

location = "Somewhere" and (Person IN (4,1)) and status in ("Closed")

I need specifically this portion;

(Person IN (4,1))

Wherein the portion of (4,1) could include a one-to-many array of number. So for example if I receive;

location = "Somewhere" and (Person IN (4,1,8,2,10,24,32,15,7)) and status in ("Closed")

Then the portion I need to extract would be;

(Person IN (4,1,8,2,10,24,32,15,7)) and the words contained are not case sensitive (eg; Person=person, IN=in) and there may be spaces between the numbers in the number[], but both the string and the number[] will be contained in (...) as shown and there may be other random stuff before and after the string contained.

A horrible attempt might be like: /(?:Person in \()(?:([\/\s"](?:,?)))(?:\))?/gm but I know obviously that’s not what I need, please advise and help a regex amateur lol.

>Solution :

You can match the opening and closing parenthesis and the comma separated digits in between, where there can be optional whitspace chars surrounding the digits.

\(Person in \(\s*\d+\s*(?:,\s*\d+\s*)*\)\)

• \(Person in \( Match (Person in (
• \s*\d+\s* Match 1+ digits between optional whitespace chars
• (?:,\s*\d+\s*)* Optionally repeat matching a comma and 1+ digits between optional whitespace chars
• \)\) Match ))

Regex demo

An Example in Javascript

const regex = /\(Person in \(\s*\d+\s*(?:,\s*\d+\s*)*\)\)/gi;
const str = `location = "Somewhere" and (Person IN (4,1)) and status in ("Closed")

location = "Somewhere" and (Person IN ( 4, 1,8,2, 10,24 ,32,15, 7 )) and status in ("Closed")

location = "Somewhere" and (Person IN ()) and status in ("Closed")

location = "Somewhere" and (Person IN ( 4 )) and status in ("Closed")

`;
console.log(str.match(regex));