How to count no. of received data of any one files?


 
Thread Tools Search this Thread
# 1  
How to count no. of received data of any one files?

Hi Guys,


I have a file where is different task_id and every task id has many received data, now we have to count no. of received data for any task_id. (received means received words, i.e. count no. of received word of any task_id)

Please help us Guys.
# 2  
Please do not leave people guessing. Show a representative sample of input, desired output, attempts at a solution and specify what OS and versions being used.
# 3  
Quote:
Originally Posted by Scrutinizer
Please do not leave people guessing. Show a representative sample of input, desired output, attempts at a solution and specify what OS and versions being used.
file name is: sms_push_123.ab:01:04

file records:
Code:
your no is received: from files sms_push_task_id_01-12345.csv
your no is received: from files sms_push_task_id_01-13345.csv
your no is received: from files sms_push_task_id_01-14345.csv
your no is received: from files sms_push_task_id_01-15345.csv
your no is received: from files sms_push_task_id_01-12145.csv
your no is received: from files sms_push_task_id_01-12245.csv
your no is received: from files sms_push_task_id_01-12445.csv

Here files is different but task_id_01 is single now we have to count no. of received words
here no. of received words is = 7 in task_id_01.

Moderator's Comments:
Mod Comment Use code tags, not quote tags for data samples

Last edited by Scrutinizer; 01-31-2015 at 06:02 AM..
# 4  
Hello aaditya321,

Could you please use following code and let me know if this helps.
Code:
awk '{sub(/\-.*/,X,$NF);A[$NF]++} END{for(i in A){print i OFS A[i]}}' Input_file

Output will be as follows.
Code:
sms_push_task_id_01 7

Kindly let me know if this helps.


Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
# 5  
Thanks a lot R Singh, please enhance your code i.e. how to work your given this code.
# 6  
Hello aaditya321,

If your question is to get explaination of above code then following is same.
Let me know if you have any other queries with complete input and required output.
Code:
sub(/\-.*/,X,$NF) means to substitue everything from - to end with NULL.
A[$NF]++ means to make an array whose index it $NF(which is now sms_push_task_id_01) 
and increment means it will count it's value with respect to each index.

Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
 

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Science: Computers
Difficulty: Medium
The very first recorded computer "bug" was a moth found inside a Harvard Mark II computer.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script to find directory is getting files in every 10 mins, if not then when last time file received

Dears, I am looking for a script which will work as a watch directory. I ha directory which keep getting files in every 10 mins and some time delay. I want to monitor if the directory getting the files in every 10 mins if not captured the last received file time and calculate the delay. ... (6 Replies)
Discussion started by: sadique.manzar
6 Replies

2. Shell Programming and Scripting

How to count data per 5 Minutes?

Hi All could u help me, i want to count data per minutes to be 5 minutes. sample data like below : 23:40 187 23:41 200 23:42 178 23:43 171 23:44 161 23:45 145 23:46 172 23:47 163 23:48 174 23:49 174expectation : 23.40 - 23.44 897 23.45 - 23.49 828thanks (2 Replies)
Discussion started by: fajar_3t3
2 Replies

3. Shell Programming and Scripting

Error files count while coping files from source to destination locaton as well count success full

hi All, Any one answer my requirement. I have source location src_dir="/home/oracle/arun/IRMS-CM" My Target location dest_dir="/home/oracle/arun/LiveLink/IRMS-CM/$dc/$pc/$ct" my source text files check with below example.text file content $fn "\t" $dc "\t" $pc "\t" ... (3 Replies)
Discussion started by: sravanreddy
3 Replies

4. UNIX for Advanced & Expert Users

Errors received while restoring my data from ext3 filesystem

Hi All, I have dual boot on my laptop - Win8 And linuxMint. From linuxmint i had copied all my data found on the NTFS partitions (on my laptop) to an external hard drive (formatted with ext3). i used rsync for this. Now after my hard disk crashed, am restoring the data back from ext3... (2 Replies)
Discussion started by: coolatt
2 Replies

5. Shell Programming and Scripting

To trigger a mail if the files have been received

Hi All, i have a folder in which we receive 6 files daily. the file name will be appended with date for ex : files that we receive on 1/9/2013 will be like file1_20130108.txt.zip file1_20130108.txt file2_20130108.txt.zip file2_20130108.txt file3_20130108.txt.zip file3_20130108.txt the... (3 Replies)
Discussion started by: mahesh300182
3 Replies

6. Shell Programming and Scripting

Count column data

Hi Guys, B07 U51C A1 44 B1 44 Yes B07 L64U A2 44 B1 44 Yes B07 L62U A2 44 B1 44 Yes B07 L11C A4 32 B1 44 NO B05 L12Z A1 12 B1 44 NO B01 651Z A2 44 B1 44 NO B04 A51Z A2 12 B1 44 NO L07 B08D A4 12 B1 44 NO B07 RU8D A4 44 B1 44 Yes B07 L58D A4 15 B1 44 No B07 LA8D A4 44 B1 44 Yes B07... (6 Replies)
Discussion started by: asavaliya
6 Replies

7. Shell Programming and Scripting

awk count how many IP have received that error

Hi all, I want to write a awk script that counts unique IPs that have received one special error. For example 25-04-2012;192.168.70.31;1254545454545417;500.0;SUCCESS 25-04-2012;192.168.70.32;355666650914;315126423993;;General_ERROR_23 30-04-2012;192.168.70.33;e;null;null;Failure... (4 Replies)
Discussion started by: arrals_vl
4 Replies

8. Shell Programming and Scripting

awk count how many unique IPs have received that error

Hi all, I want to write a awk script that counts unique IPs that have received one special error. For example 25-04-2012;192.168.70.31;1254545454545417;500.0;SUCCESS 25-04-2012;192.168.70.32;355666650914;315126423993;;General_ERROR_23 30-04-2012;192.168.70.33;e;null;null;Failure... (2 Replies)
Discussion started by: arrals_vl
2 Replies

9. Shell Programming and Scripting

count horizontal data

dear all.. i need help i have data ID,A,B,C,D,E,F,G,H --> header 917188,4,1,2,1,4,6,3,5 --> data i want output : ID,OUT1,OUT2,OUT3 --> header 917188,3,3,2 where OUT1 is count of 1 and 2 from $2-$9 OUT2 is count of 3 and 4 from $2-$9... (3 Replies)
Discussion started by: buncit8
3 Replies

10. Shell Programming and Scripting

How do I write a ksh script that will check if all ftp files are received?

I am trying to code a ksh script that will check to see if all 26 incoming ftp files have been received before proceeding to the next function, which is to rename each file. Here is the pseudo-code of what I am trying to do: <<STEP_1>> IF all ALS files have been transmitted then... (2 Replies)
Discussion started by: doug145
2 Replies

Featured Tech Videos