NAME SUM ITEMS_A ITEMS_B ITEMS_C BAA 1 1348396499 134000 BAA 10 1333333333 002333 ITC 9 1340014296 181818 ITC 10 1349999999 134110 BAA 29 1346512572 181919 BAA 100 1349990990 * FAC 3 1346048490 134795 122233 FAC 10 1346666655 181919 130303 BAB 9 1345100000 181919 ... #### If NAME =~ /BAA/ if ITEMS_A =~ /^134/ AND ITEMS_B =~ /^134/ THEN TBAA+=SUM a++; elsif ITEMS_A =~ /^134/ AND ITEMS_B !~ /^(134|00)/ THEN OBAA+=SUM b++; elsif ITEMS_A =~ /^134/ AND ITEMS_B =~ /^00/ THEN IBAA+=SUM ab++; else EBAA+=SUM c++; elsif NAME =~ /ITC/ if ITEMS_A =~ /^134/ AND ITEMS_B =~ /^134/ THEN TITC+=SUM d++; elsif ITEMS_A =~ /^134/ AND ITEMS_B !~ /^134/ THEN OITC+=SUM e++; else EITC+=SUM f++; elsif NAME =~ /FAC/ if ITEMS_A =~ /^134/ AND ITEMS_B =~ /^134/ THEN if ITEMS_C !~ /130303/ THEN TFAC+=SUM g++; else TXFAC+=SUM h++ elsif ITEMS_A =~ /^134/ AND ITEMS_B !~ /^134/ THEN if ITEMS_C !~ /130303/ THEN TYFAC+=SUM i++; else TZFAC+=SUM j++ else if ITEMS_A =~ /^134/ AND ITEMS_B =~ /^134/ THEN UNK+=SUM k++; elsif ITEMS_A =~ /^134/ AND ITEMS_B !~ /^134/ THEN UNK2+=SUM l++; else UNK3+=SUM m++; #### NAME TOTAL_SUM TOTAL BAA (134->134) 140 5 (134->other) 123 4 (134->00???) 20 1 (134->unknown) 0 0 ITC (134->134) 100 10 (134->other) 30 4 (134->unknown) 0 0 FAC (134->134->130303) 30 3 (134->134->other) 90 4 (134->other->130303) 60 2 (134->other->other) 1 1 OTH (134->134) 10 1 (134->other) 9 1 (134->unknown) 1 1