topic Re: Count number of rows in column, with matching character in Discussions

Count number of rows in column, with matching character

Jackie_ — Thu, 15 Jun 2023 16:10:27 GMT

Hi,

I'm trying to wirte a jsl code to get a count of the number of strings(rows) with a certain specified characters at a certain position within the column.

Eg. I want to get the count of the number of the rows containing sting "1" between the rows containing only three "P" characters

In this case, the row count would be 26. Please advice.

Thanks,

Jackie

Re: Count number of rows in column, with matching character

jthi — Thu, 15 Jun 2023 16:38:43 GMT

Where do you want to store those results? Can there be more or less than 3Ps in row and if there can be, should the calculation for those Ps be ignored?

Re: Count number of rows in column, with matching character

Jackie_ — Thu, 15 Jun 2023 16:43:53 GMT

@jthi

So it can be store in a variable maybe N_rows something. No, it has to be 3Ps in a row and yes ignore the calculate for other Ps

Re: Count number of rows in column, with matching character

Craige_Hales — Thu, 15 Jun 2023 17:06:44 GMT

Here's a pattern matching idea

dt = Open( "/Z:/data table_sample.jmp" );
// turn the column into a string
txt = Concat Items( dt:column1 << getvalues, "" );
Pat Match(
	txt,
	"PPP" + Pat Pos() >> pos + Pat Span( "1" ) >> run + "PPP" +
	Pat Test(
		Show( pos + 1, Length( run ) );
		0; // this time the test fails to make it retry the match
	)
);

pos + 1 = 30;
Length(run) = 26;
pos + 1 = 88;
Length(run) = 26;

Re: Count number of rows in column, with matching character

txnelson — Thu, 15 Jun 2023 17:12:53 GMT

Craige,

Neat solution

Re: Count number of rows in column, with matching character

Jackie_ — Thu, 15 Jun 2023 17:46:25 GMT

Thanks Craige!