I have different files with same fileformat with filenames like '20080103*CUST*.IMP'. ( yyyymmdd)
File contains data as below said:
1200|aaa
1200|bbb
1200|ccccc
1201|dddddd
1201|ee
1201|ff
1201|hhhhh
1201|kkk
1203|gggg
Question : I need to get the date from the filename and below that
count of uniq values in first column.
Example:
20080103
1200 3
1201 5
1203 1
Thanks in Advance.
Hope someone would help me on this