Count number of rows in column, with matching character

[#1]

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

[#2]

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?

[#3]

@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

[#4 · Accepted solution]

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;

[#5]

Craige,

Neat solution

[#6]

Thanks Craige!