Bogus Total count


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Bogus Total count
# 1  
Old 04-16-2010
Question Bogus Total count

I have a shell script that I am pulling different zip file packages and totaling how many of each type of package is in the directory. I get a bogus total count of one in the middle of my output file (highlighted in RED) and not sure why, also would like to get a grand total of all files but not sure how to do this any ideas?

N PKG.MortgageCreditScoreDisclosure
Total: 16

N PKG.MortgageAppraisalDelivery
Total: 6

N PKG.MortgageRegulationB
Total: 3

N PKG.MortgagePrivacyNotice
Total: 9

N PKG.MortgageDeclination
Total: 1

Total: 1

N PKG.MortgageCommitment
Total: 8

E PKG.Mortgage3DayDisclosure
Total: 7

N PKG.MortgageRateLock
Total: 6

Code:

Code:
CEOUTFILE1="C:/tmp/DLYPKGS.txt"

find . -mtime 0 -mtime -1 | tr -s '/','-' '^' | cut -f2,3 -d"^" | tr -s '^' ' ' |
awk '{arr[$0"\n" echo "Total:"]++} END {for(i in arr) { print"\n" i, arr[i]}} ' >> $CEOUTFILE1


any help would be greatfully appreciated.

Last edited by Franklin52; 04-16-2010 at 10:11 AM.. Reason: Please use code tags!
# 2  
Old 04-16-2010
Without knowing anything about what your data looks like, my guess is that $0 contains nothing but blanks for that errant total line. Compare the output of find to what the final tr in the pipeline is feeding awk (you can do this with a couple of tee commands, one after the find and one after the final tr). The tr|cut|tr is probably mangling something in a manner you did not intend.
# 3  
Old 04-16-2010
You could try adding a -regex or -name to find, making sure the filenames returned by find are in an acceptable format, or add a grep right before your awk.

js.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Solaris

Reset MPxIO total path count

We recently moved our netapp disks onto new infrastructure by attaching the new controllers to our fibre switch and netapp migrating the disks. Disks kept the same address. We originally had 4 paths, but after attaching the new controllers we had 8. Now I want to remove the old paths. But can't. ... (5 Replies)
Discussion started by: garydeena
5 Replies

2. Shell Programming and Scripting

Count total duplicates

Hi all, I have found another post threads talking about count duplicate lines, but I am interested in obtain the total number of duplicates. For example: #file.txt a1 a2 a1 a3 a1 a2 a4 a5 #out 3 (lines are duplicates) Thank you! (12 Replies)
Discussion started by: mikloz
12 Replies

3. UNIX for Dummies Questions & Answers

Count total image in directory

Dear all, I have a directory consisted of files in .jpg, .jpeg etc..all of them are image 20140411030143_62811159403_92886.jpg 5/11/2014 15:01 197K 20140415024737_62811618747_116460.jpg 4/15/2014 14:47 17K 20140415031003_62811618747_109192.jpg 4/17/2014 15:10 17K... (4 Replies)
Discussion started by: radius
4 Replies

4. UNIX for Dummies Questions & Answers

In ls -l remove total count

Hi All, When i give ls -ltr i get 'total 10' like this along with files long listing. is there any option in ls command to remove this line or do we need use head -1 command only. $ls -ltr total 45 -rw-r--r-- 1 abc g1 0 Jul 17 07:20 0 -rw-r--r-- 1 abc g1 744 May 9 12:10 a -rw-r--r--... (1 Reply)
Discussion started by: HemaV
1 Replies

5. Shell Programming and Scripting

Finding total count of a word.

i want to find the no:of occurrences of a word in a file cat 1.txt unix script unix script unix script unix script unix script unix script unix script unix script unix unix script unix script unix script now i want to find , how many times 'unix' was occurred please help me thanks... (6 Replies)
Discussion started by: mahesh1987
6 Replies

6. Shell Programming and Scripting

total count of a word in the files

Hi Friends, Need help regarding counting the word "friend" in files test1.txt and test2.txt. ( there is no gap/space between word ) cat test1.txt himynameisrajandiamfriendofrajeshfriend wouldyouliketobemyfriend. cat test2.txt himynameisdostandiamfriendofdostfriend... (2 Replies)
Discussion started by: forroughuse
2 Replies

7. Shell Programming and Scripting

Total Count using AWK

Hi Everybody, I have the following example file... 199|TST-GURGAON|GURGAON|1 199|TST-GURGAON|GURGAON|1 199|TST-GURGAON|GURGAON|1 199|TST-GURGAON|GURGAON|1 199|TST-GURGAON|GURGAON|1 199|TST-GURGAON|GURGAON|1 199|TST-GURGAON|GURGAON|1 199|TST-GURGAON|GURGAON|1 199|TST-GURGAON|GURGAON|1... (8 Replies)
Discussion started by: sraj142
8 Replies

8. UNIX for Advanced & Expert Users

Count total file downloaded using FTP

Hi All, I'm developing a FTP script as below: ftp -v -n <IP_ADDRESS> << EOF user avery jSqaqUU2 lcd /directory/folder/ ascii prompt mget * bye EOF I would like to enhance the script to count the total file downloaded. For example, once the script run i want the message "Total <n>... (1 Reply)
Discussion started by: cas553
1 Replies

9. UNIX for Advanced & Expert Users

total count of inodes in a mount

is there Any command to get total count and number of free inodes on a mount. please help (5 Replies)
Discussion started by: pharos467
5 Replies
Login or Register to Ask a Question