Count no of occurrence of the strings based on column value

Shell Programming and Scripting
1

Can anyone help me to count number of occurrence of the strings based on column value. Say i have 300 files with 1000 record length from which i need to count the number of occurrence string which is existing from 213 to 219. Some may be unique and some may be repeated.

2

Can you post an example -- a couple lines of input and desired output?

3

Test data (Input data):

IN46236 TRE 317-691-741947558020901EN1HGCM82614A0001722004HONDA ACCORD U-S- 0001-01-012011-04-112011-04-11A12345FBurd Ford, Inc.
GA30214 TRE 000-000-000094536775208EN1HGCM72673A0013972003HONDA ACCORD U-S- 0001-01-012011-04-072011-04-07B12345LAllan Vigil Ford of Fayetteville, Inc.
CO80503 TRE 720-438-456709740713120ENJHLRE48569C0025272009HONDA CR-V 0001-01-012011-04-092011-04-08C23456ALongmont Ford
AZ85743 TRE 000-000-000058715232407ENJTEDW21AX600040012006TOYOTA HIGHLANDER 0001-01-012011-04-092011-04-09D78636CHolmes Tuttle Ford, Lincoln-Mercury
NH03055 TRE 603-867-465107757895420EN5J6YH28574L0059762004HONDA ELEMENT 0001-01-012011-04-122011-04-12A12345LBest Ford Lincoln
GA30540 TRE 706-635-589558241949120ENJTMZF33V29D0062112009TOYOTA RAV4 0001-01-012011-04-072011-04-07A12345DRonnie Thompson Ford-Mercury
CA92376 TRE 909-877-153353033524707ENKNAFE1624750071172007KIA SPECTRA5 0001-01-012011-04-122011-04-12C23456DCitrus Motors
AR71646 TRE 870-853-572147762329806EN1NXBU40E79Z0075622009TOYOTA COROLLA 0001-01-012011-04-072011-04-07A12345VRyburn Motor Company, Inc.
MN56071 TRE 952-686-146403434361620EN4A3AB76S66E0108782006MITSUBIGALANT 0001-01-012011-04-062011-04-06A12345XNew Prague Ford Lincoln Mercury
MD21286 TRE 410-337-722287552922909ENJTEBT14R1480109092004TOYOTA 4RUNNER 0001-01-012011-04-122011-04-12B12345LBob Davidson Ford Lincoln
FL33067 TRE 954-592-941240740545220ENJNKCV61EX9M0114092009INFINITG37 0001-01-012011-04-092011-04-09A12345LMaroone Ford of Margate
MI49224 TRE 614-307-460899043860620EN5J6RE4H35BL0119092011HONDA CR-V 0001-01-012011-04-012011-04-01A12345VAlbion Motors Ford, Inc.

Output:
Out of 12 lines we have 7 strings repeated and reset of them are 2 and 1 which are existing in same column value.
A12345 - 7
B12345 - 2
C23456 - 2
D78636 - 1

4

It's still not very clear to me. But I'll give it a shot in the dark:

$ awk -F"-[0-9]+" '{s=gensub(/([0-9])[^0-9]*/,"\\1","g",$NF); cnt++}END{for(i in cnt){print i " " cnt|"sort"}}' input
A12345 7
B12345 2
C23456 2
D78636 1

THe awk command works as follows (explanation on the first line of input):
It takes the last field after dash and number(s):

IN46236 TRE 317-691-741947558020901EN1HGCM82614A0001722004HONDA ACCORD U-S- 0001-01-012011-04-112011-04-11A12345FBurd Ford, Inc.

, then it throws away everything beyond the last number

A12345FBurd Ford, Inc.

and counts the occurrences of these.

5

Thanks for your reply. Since file length is 1000 i have not posted entire line. Number value exits after 213-219 also. My requirement is fetch all string from 213 to 219 position from all 300 files and count the number of occurrence.
For example cut -c 213-219 filename then count the occurrence.

6 
cut -c213-219 yourfile* | sort | uniq -c

?

7

uniq is not required. We need to find the counts (occurrence of the strings based on column value for multilple files).

8

Perfect. Thanks...