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: