topic Re: REGEX HELP with White Spaces in Discussions

REGEX HELP with White Spaces

AlexS — Sat, 10 Jun 2023 23:16:24 GMT

Hello

I can do what i want for regex in an editor but I'm having trouble switching it over to use for JMP.

The following does what i need it do to in the editor

([E]|[e])[2]|(231)

i can't seem to get to work exactly like i need it to in JMP i got as far as the below

Regex( :TEXT, "(E2|e2|231\d?)", "\1" )

it will pick up E2 or e2 no problem but for 231 i need it to only extract when there is whitespace either side of it.

I have been looking through the community but can't find exactly what I need.

In an ideal world it will display all results in the column not just one?

I'm sure someone out there can tell me seconds how to do it

Re: REGEX HELP with White Spaces

gzmorgan0 — Sun, 19 Jul 2020 00:26:40 GMT

@AlexS ,

\s is usually the symbol for white space or \sb. However, it will be easier to give your a response if you provide an example of one row of column :text and what you are trying to extract, Make something up if it is proprietary.

Re: REGEX HELP with White Spaces

AlexS — Sun, 19 Jul 2020 06:38:28 GMT

@gzmorgan()

So example text would be

Jsjsjjs 231 jdjdjdj 2377474742311

I don’t want it from the second numeric sequence just when there is white space either side at the moment it would pick up 2311 when all I want is 231 if there is one

Thank you

Re: REGEX HELP with White Spaces

Mark_Bailey — Sun, 19 Jul 2020 12:26:56 GMT

This example shows the expression to get the second part of your target based on the example that you provided.

Regex(
	"Jsjsjjs 231 jdjdjdj 2377474742311",
	"\s(\d+)\s",
	"\1"
);

Re: REGEX HELP with White Spaces

gzmorgan0 — Sun, 19 Jul 2020 16:44:43 GMT

@AlexS ,

Mark, @Mark_Bailey , provided you with the pattern to find any number in the first pattern "space + any number + space"

Maybe I misread your response but it seemed to me you were looking for the specific sequence space + 231 + space.

If yes, an alternative solution is to use the Contains() function. The code is a little more readable. Note REGEX returns a string, so if you want the number you need the Num() function. A table with both functions is attached to this post.

If( Contains( :Text, " 231 " ),
	231
)

Re: REGEX HELP with White Spaces

AlexS — Sun, 19 Jul 2020 18:17:15 GMT

@gzmorgan0,
,

Both will be required in some form but specifically to this request I need it for ‘231’ so thanks to both of you.

How would I get it to search for all 3 and then put it all in one column if it’s there? Is it just a case of creating multiple Regex along with concatenation of columns?

So for example I am looking for E2 or e2 or 231 but it will return one of those only. What I’d like is for it to return everything it finds?

Thank you for your direction and help

Re: REGEX HELP with White Spaces

txnelson — Sun, 19 Jul 2020 18:58:33 GMT

Here is a formula that should work to get what you want. The column you apply this to, needs to be a Character Column.

If( Row() == 1,
	getValues = Function( {},
		returnVal = "";
		If( Contains( :Text, " 231 " ),
			returnVal = "321"
		);
		If( Contains( :Text, " e2 " ),
			If( returnVal != "",
				returnVal = returnVal || ", "
			);
			returnVal = returnVal || "e2";
		);
		If( Contains( :Text, " E2 " ),
			If( returnVal != "",
				returnVal = returnVal || ", "
			);
			returnVal = returnVal || "E2";
		);
		returnVal;
	)
);
theValue = getValues();

Re: REGEX HELP with White Spaces

AlexS — Mon, 20 Jul 2020 07:26:30 GMT

Excellent thank you for your time.