topic Re: counting total item in each cell that contain different pattern in Discussions

counting total item in each cell that contain different pattern

dadawasozo — Fri, 09 Jun 2023 16:57:06 GMT

Hi,
I want to get the total count of the item in the cell under setting columns. Can someone give me suggestion how I can code it so it will take the value under :setting column and count the total number like what shown under :Total Items. Many Thanks.

Re: counting total item in each cell that contain different pattern

txnelson — Fri, 15 Apr 2022 00:32:30 GMT

Here is the formula for the column Total Items, that I came up with.

count = 0;
i = 1;
While( Word( i, :setting, "," ) != "",
	theWord = Word( i, :setting, "," );
	If( Contains( theWord, "-" ) | Contains( theWord, ":" ),
		Show( Row(), theWord );
		count = ((count + Num( Word( 2, theWord, "-:" ) )) - Num( Word( 1, theWord, "-:" ) )) + 1;
	,
		count
		++);
	i++;
);
count;

Re: counting total item in each cell that contain different pattern

dadawasozo — Fri, 15 Apr 2022 00:48:07 GMT

This is amazing! I was only able to do one type str count. I learn new thing. Thanks a lot.