topic find unique strings separated by comma for each row in a column and count the total recurrence in Discussions

find unique strings separated by comma for each row in a column and count the total recurrence

dadawasozo — Sat, 05 Jul 2025 21:04:11 GMT

Hi,

I wonder if there is a way to create column with formula to find unique strings separated by comma in a column and count total recurrence of each like below?

Re: find unique strings separated by comma for each row in a column and count the total recurrence

txnelson — Sun, 06 Jul 2025 02:36:27 GMT

Here is one way of handling this

Unique Item formula

x = Words( :Input, "," );
For Each( {element, index}, x, x[index] = Trim( element ) );
x = Associative Array( x ) << get keys;
x = Concat Items( x, "," );

Total Recurrence formula

x = Words( :Input, "," );
For Each( {element, index}, x, x[index] = Trim( element ) );
theList = Associative Array( x ) << get keys;
value = "";
For Each( {element}, theList, value = value || "," || Char( N Rows( Loc( x, element ) ) ) );
Substr( value, 2 );

Re: find unique strings separated by comma for each row in a column and count the total recurrence

dadawasozo — Sun, 06 Jul 2025 02:26:35 GMT

Hi Jim,

it looks like both formula is same

Re: find unique strings separated by comma for each row in a column and count the total recurrence

txnelson — Sun, 06 Jul 2025 02:37:28 GMT

My error......I corrected my initial post to the correct formula

Re: find unique strings separated by comma for each row in a column and count the total recurrence

dadawasozo — Sun, 06 Jul 2025 02:43:30 GMT

Thank you for the helps!!!