#### jtm2020hyo

##### Technical User

I have an Variable like this:

ArrSource = A1,B2,C1; A2,B2,C1; A3,B2,C2; A4,B2,C2;A5,B2,C3; A6,B2,C4; A7,B2,C5;

'Note: ArrSource is String

How can I count all "C*" repeated values, I mean something like this:

1) Convert Arr1 to multiple array:

Arr1 = A1,B2,C1

Arr2 = A2,B2,C1

Arr3 = A3,B2,C2

Arr4 = A4,B2,C2

Arr5 = A5,B2,C3

Arr6 = A6,B2,C4

Arr7 = A7,B2,C5;

2) Then count all repeated value in the index 2 (third column) then store it in a variable in index 0 and their unique/repeated value in index 1

Arr_01 = 2,C1

Arr_02 = 2,C2

Arr_03 = 1,C3

Arr_04 = 1,C4

Arr_05 = 1,C5

3) concatenate such value with the Unique Value in a Variable like this:

ArrFinal = 2,C1 ; 2,C2 ; 1,C3 ; 1,C4 ; 1,C5

Is there some help?

Tags (0)

Add tags

Report

2 REPLIES

Sort: