This is a summary of the different ICL formats from our CLAS_ICL as of 3-18-2004. I started with db2 -x "select distinct(icl) from clas_icl" > distinct.icl and here are the results of egrep-ing for various patterns. Note that the "Counts" column is the number of ICL's that match that format, not the number of patents or rows in the CLAS_ICL table that have that pattern. D=Digit (1-9) d=Digit (0-9) l=Letter (A-Z, not lowercase) c=Character (digit or uppercase letter) x=Anything ?=Not Letters or Digits Database Format Display Format Counts =============== ===================== ======= cccc cccc 1,930 cccc 00D cccc D or cccc D/ 377 cccc 00l cccc l or cccc l/ 27 cccc 0Dd cccc Dd or cccc Dd/ 669 cccc 0Dl cccc Dl or cccc Dl/ 4 cccc 0ld cccc ld or cccc ld/ 0 cccc 0ll cccc ll or cccc ll/ 2 cccc ccc cccc ccc or cccc ccc/ 629 cccc cccc cccc ccc/c 1,947 cccc ccccc cccc ccc/cc 128,175 cccc cccccc cccc ccc/ccc 15,584 cccc ccccccc cccc ccc/cccc 1,458 cccc cccccccc cccc ccc/ccccc 1,790 cccc ccccccccc cccc ccc/cccccc 448 cccc cccccccccc cccc ccc/ccccccc 106 cccc ccccccccccc cccc ccc/cccccccc 481 --------------- ----------- 16 Valid ICL's 153,727 Valid ICL's ? 9 ?? 7 ??? 389 cccc c 533 cc/c c 27 cccc / 7 cccccc 1 9/12 7 1 /000 00l 2 cccc xxx 9 C22b 01500 1 cccc cc 858 c/dd 17 Bxxx 4 cccc 000 80 cccc c/cc 1,316 cccx xxxx 75 cccc cc/cc 1,663 cccc c/ccc 89 xxxx xxxxx 26 xccc xxxxxx 504 cccc ccc/ccc 1,869 (ccc cccc/cc 71 cccc cccc/cc 41 cccc xxxxxxx 49 cccc ccc/cccc 115 cccc ccc/cccccc 269 cccc ccccccc- 145 cccc xxxxxxxx 78 //(c cccccc/cc 177 //cc cccccc/cc 2,002 //cc cccccc:cc 213 cccc cc/cccccc 59 cccc c/cc;c/cc 154 cccc xxxxxxxxx 10 //cc cccccc/ccc 169 cccc d{1,3}/d{2,4};d{1,3}/d{2,4} 381 cccc d{5,7}/d{1,3}/d{2,3} 118 xxxx xxxxxxxxxx 10 Plus other cases listed in di6 813 ----------------- ----------- 201 1,260 5,900 5,000 ----------------- ----------- 39+ Invalid ICL's 12,361 Invalid ICL's 153,727 Valid ICL's 20,707 Lost in the Wash ----------------- ----------- 186,795 Total Different ICL's