Shell Programming and Scripting

Hi I have a set of files in one directory like below

Code:

FIN_TASK1.csv
FINA_TASK2.csv
FIN_TASK3.csv

.

I want a command to print the count in each file and the correspong file name into one file.My expected output is given below

Code:

cat filcount.txt
 2 "FIN_TASK1.csv"
      4 "FIN_TASK2.csv"
     12 "FIN_TASK3.csv"

Also in another folder I have similar file as in the above output.So I want to compare this two files by matching the file name and see the % of difference in the count.The file name in both the files can be in different order.

Code:

cat errorcount.csv
4 "FIN_TASK3.csv"
8 "FIN_TASK1.csv"
12 "FIN_TASK2.csv"

so if

You can get some idea using following url

Script to determine Date,TotalFile,total size of file based on date

Thanks for the reply.

I want the count in each file instead of file size

Hello ginrkf,

Assuming like your file may have spaces in starting, not sure about your query of percentage differences, following solution
can be taken as a start up. Please let us know exact desired output for same we may help you.

Code:

awk 'FNR==NR{X[$2]=$1;next} {gsub(/^[[:space:]]+/,Y,$0);} ($2 in X){C=X[$2] > $1?X[$2] - $1:$1 - X[$2];print $2 OFS C}' errorcunt filcount

Output will be as follows.

Code:

"FIN_TASK1.csv" 6
"FIN_TASK2.csv" 8
"FIN_TASK3.csv" 8

Note: I have checked here the values like we should not get differences in minus so let us know how we need to take difference
also is it always filcount-errorcunt or it can be bi directional too.


Thanks,
R. Singh