Searching every cell in one column to find a specific content

Question

Hi all,

I have a jmp data table with a column that contains different strings at each row. I would like to know if I can loop that column to find a specific part of the string in that cell.

This an example of the strings:

Class: 10 Table:15 Stat:NA loc:NA teacher:Sam --> content of the cell

Class: 11 Table:11 Stat:NA loc:NA teacher:Sam

The challenge is that I have different class # and different table #. However, I only need to find the cells the starts with "Class: #" and grab the rest of the cells into a list.

So my question is: can I do a partial cell search at that specifc column?

jthi · Answer

Do you mean the Class B1 part? You can modify the regex by adding \d? inside brackets (https://regex101.com/r/Yfh6pZ/1). \d will match a digit and ? will match the token before it ZERO or ONE times. If you don't want to capture groups which have no digits, leave out ? or replace it with {1}

[
	"Class B" => {"20::Class B"}, 
	"Class B1" => {"21::Class B1", "22::Class B1"}, 
	"Class C" => {"30::Class C"}, 
	"Class C1" => {"31::Class C1"}, 
	"Class C2" => {"32::Class C2"}, 
	"Class: A" => {"10::Class: A"}, 
	"Class: A1" => {"11::Class: A1"}, 
	"Class: A2" => {"12::Class: A2"}
]

RA899 · Answer

Thanks @jthi. This works perfectly.

Follow up question:

I would like to group the list into subgroups based on only and only the first digit. I tried to use regex Anchors to do so. However, instead of matching only the first digit, it matches the first and whatever digits comes after.  Any guidance is appreciated.

jthi · Answer

This might give some idea what you could do

Names Default To Here(1);

mylist = {"10::Class: A", "11::Class: A1", "12::Class: A2", "20::Class B", "21::Class B1",
"22::Class B1", "30::Class C", "31::Class C1", "32::Class C2"};

class_pattern = "\d+::(Class:? [A-Z])";

aa = Associative Array();
For Each({myitem}, mylist,
	res = Regex(myitem, class_pattern, "\1");
	If(!Contains(aa, res),
		aa[res] = {};
	);
	Insert Into(aa[res], myitem);
);

show(aa);

https://regex101.com/r/itqqww/1 for explanation of the regex pattern