Count values occurance in list

HCL Domino Domino Forum
1

I have a text list:

4;4;4;4;4;4;5;5;5

I need to get the count of numbers

4 → 6 times

5 → 3 times

The result in a computed field should be then 6;3

No idea, how to do this ;-/

Any ideas?

2

Subject: Count values occurance in list

myList:=4:4:4:4:4:4:4:5:5:5;stored:=“A”:“B”:“C”:“D”:“E”:“F”:“G”:“H”:“I”:“J”:“K”;

A:=0;

B:=0;

C:=0;

D:=0;

E:=0;

F:=0;

G:=0;

H:=0;

I:=0;

J:=0;

K:=0;

@For(n:=1;n<=@Elements( myList);n:=n+1;

z:=myList[n];

@Set(stored[z]; @Eval(stored[z])+1)

);

A:B:C:D:E:F:G:H:I:J:K

Seems to work… but the storage is limited to the number of defined variables.