Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Total count in each category for given file list
Top Forums Shell Programming and Scripting Total count in each category for given file list Post 302916548 by santoshdrkr on Wednesday 10th of September 2014 03:07:00 PM
Old 09-10-2014
Total count in each category for given file list
I have list of file names in filename.txt
below is file format
>>File1
_________________________
Code:
01~12345~Y~YES~aaaaa~can
02~23456~N~NO~bbbbb~can
.
.
.
99~23

__________________________

Need to find total count from each file depending on specific string and add them to have total count in each category.

Code:
1. directory/${LINE}|tail -1|grep -i "99"|cut -d  '~' -f 2
2. directory/${LINE}|grep '~YES~'| wc -l
3. directory/${LINE}|grep '~No~'| wc -l

I need output as :
Code:
1.total count : 23  #addition of trailer values for each file '99' suggests it's a trailer
2. YES : 10  # total occurrences of '~YES~' 
3. NO : 5     # total ocurrences of '~NO~'

Last edited by santoshdrkr; 09-10-2014 at 11:45 PM.. Reason: Please use [code][/code] tags.
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Total file size of a subset list

Hello! I'm trying to find out the total file size of a subset list in a directory. For example, I do not need to know the total file size of all the files in a directory, but I need to know what the total size is of say, "ls -l *FEB08*" in a directory. Is there any easy way of doing this? ... (3 Replies)
Discussion started by: tekster757
3 Replies

2. 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

3. UNIX for Dummies Questions & Answers

Grep bunch of gzip files to count based on category

Started using unix commands recently. I have 50 gzip files. I want to grep each of these files for a line count based particular category in column 3. How can I do that? For example Sr.No Date City Description Code Address 1 06/09 NY living here 0909 10st st nyc 2 ... (5 Replies)
Discussion started by: jinxx
5 Replies

4. UNIX Desktop Questions & Answers

What is the way to get a total count of students and with highest marks from a file?

I have different things that I was trying to do but am kind of struggling with this since I'm a Linux noob. I have a files with student names ,marks,year school the . What is the most efficient way to get a total count of students and student with highest marks Initially I tried to get a count... (1 Reply)
Discussion started by: anil2103
1 Replies

5. UNIX for Dummies Questions & Answers

How to find count total number of pattern in a file …?

How to find count total number of pattern in a file … File contains : a.txt ------------- aaa bbb nnn ccc aaa bbb aaa ddd aaa aaa aaa aaa grep -c aaa a.txt Op: 4 ( But my requirement is should count the total no of patterns as 7 ) (4 Replies)
Discussion started by: Jitten
4 Replies

6. 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

7. UNIX for Dummies Questions & Answers

To count total of specific character in a file and save its value to a variable

Hi all, I have a file that contains characters. How do I get total of spesific character from that file and save the count to a variable for doing for calculation. data.txt 1 2 2 2 2 3 3 4 5 6 7 8 5 4 3 4 (5 Replies)
Discussion started by: weslyarfan
5 Replies

8. Shell Programming and Scripting

Category and count with awk

I want to categorize and count the as below: Input file: A1 G1 C1 F1 A2 G1 C1 F1 A3 G1 C1 F2 A4 G1 C2 F2 A7 G1 C2 F2 A8 G1 C2 F3 A11 G1 C2 F3 A23 G1 C2 F3 B4 G1 C2 F3 AC4 G2 C3 F4 B6 G2 C4 F4 BB5 G2 C4 F4 A25 G2 C5 F4 B13 G2 C5 F5 D12 G2 C5 F5 D2 G2 C5 F5 (3 Replies)
Discussion started by: aydj
3 Replies

9. Shell Programming and Scripting

Total record count of all the file present in a directory

Hi All , We need one help on the below requirement.We have multiple pipe delimited .txt file(around 100 .txt files) present on one directory.We need the total record count of all the files present in that directory without header.File format as below : ... (8 Replies)
Discussion started by: STCET22
8 Replies

LEARN ABOUT OSX

vm_stat

VM_STAT(1)						    BSD General Commands Manual 						VM_STAT(1)

NAME

     vm_stat -- show Mach virtual memory statistics

SYNOPSIS

     vm_stat [[-c count] interval]

DESCRIPTION

     vm_stat displays Mach virtual memory statistics.  If the optional interval is specified, then vm_stat will display the statistics every
     interval seconds.	In this case, each line of output displays the change in each statistic (an interval count of 1 displays the values per
     second).  However, the first line of output following each banner displays the system-wide totals for each statistic.  If a count is pro-
     vided, the command will terminate after count intervals.  The following values are displayed:

     Pages free
	     the total number of free pages in the system.

     Pages active
	     the total number of pages currently in use and pageable.

     Pages inactive
	     the total number of pages on the inactive list.

     Pages speculative
	     the total number of pages on the speculative list.

     Pages throttled
	     the total number of pages on the throttled list (not wired but not pageable).

     Pages wired down
	     the total number of pages wired down.  That is, pages that cannot be paged out.

     Pages purgeable
	     the total number of purgeable pages.

     Translation faults
	     the number of times the "vm_fault" routine has been called.

     Pages copy-on-write
	     the number of faults that caused a page to be copied (generally caused by copy-on-write faults).

     Pages zero filled
	     the total number of pages that have been zero-filled on demand.

     Pages reactivated
	     the total number of pages that have been moved from the inactive list to the active list (reactivated).

     Pages purged
	     the total number of pages that have been purged.

     File-backed pages
	     the total number of pages that are file-backed (non-swap)

     Anonymous pages
	     the total number of pages that are anonymous

     Uncompressed pages
	     the total number of pages (uncompressed) held within the compressor

     Pages used by VM compressor:
	     the number of pages used to store compressed VM pages.

     Pages decompressed
	     the total number of pages that have been decompressed by the VM compressor.

     Pages compressed
	     the total number of pages that have been compressed by the VM compressor.

     Pageins
	     the total number of requests for pages from a pager (such as the inode pager).

     Pageouts
	     the total number of pages that have been paged out.

     Swapins
	     the total number of compressed pages that have been swapped out to disk.

     Swapouts
	     the total number of compressed pages that have been swapped back in from disk.

     If interval is not specified, then vm_stat displays all accumulated statistics along with the page size.

Mac OS X							  August 13, 1997							  Mac OS X
All times are GMT -4. The time now is 09:30 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy