topic Re: How to return all matched results from Regex? in Discussions

How to return all matched results from Regex?

robot — Fri, 04 Apr 2025 18:25:19 GMT

How can I return all results from a Regex search?

I am using JMP 18.1.2.

Names Default To Here( 1 );
string = "I am looking for ^this^, ^that^, and sometimes ^those^.";
result = Regex( string, "\^([^\n]*?)\^" ); // Only returns first match.

Re: How to return all matched results from Regex?

Mark_Bailey — Fri, 04 Apr 2025 18:59:45 GMT

The Regex Match() function might work.

Re: How to return all matched results from Regex?

robot — Fri, 04 Apr 2025 19:54:48 GMT

Thanks for the input. Regex Match() still does not return all results. At least not the way I have written it.

Names Default To Here( 1 );
string = "I am looking for ^this^, ^that^, and sometimes ^those^.";

result = Regex( string, "\^([^\n]*?)\^" ); // Returns "^this^".
Show( result );

results = Regex Match( string, "\^([^\n]*?)\^" ); // Returns {"^this^", "this"}.
Show( results );

Re: How to return all matched results from Regex?

jthi — Fri, 04 Apr 2025 19:58:13 GMT

To my knowledge just using Regex (or Regex Match) are not able to do it at the moment, . You could use Python but you can also use JSL with a loop

Names Default To Here(1);
string = "I am looking for ^this^, ^that^, and sometimes ^those^.";
result = Regex(string, "\^([^\n]*?)\^"); // Only returns first match.

matches = {};

While(!Is Missing(result = Regex(string, "\^([^\n]*?)\^")),
	Substitute Into(string, result, "");
	Insert Into(matches, result);
);

show(matches); // matches = {"^this^", "^that^", "^those^"};

or the much more complicated option of JMPs "own" pattern matching Scripting Guide > Types of Data > Pattern Matching

Re: How to return all matched results from Regex?

robot — Fri, 04 Apr 2025 20:11:27 GMT

Thanks!

Re: How to return all matched results from Regex?

txnelson — Fri, 04 Apr 2025 21:47:35 GMT

Using JMP's Word() function along with Jarmo's methodology one can also solve the problem.

Names Default To Here(1);
string = "I am looking for ^this^, ^that^, and sometimes ^those^.";
result = Regex(string, "\^([^\n]*?)\^"); // Only returns first match.

matches = {};

While(!Is Missing(result = word(2,string, "^")),
	Substitute Into(string, "^"||result||"^", "");
	Insert Into(matches, result);
);

show(matches); // matches = {"^this^", "^that^", "^those^"};

matches = {"this", "that", "those"};