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

Login or Register to Ask a Question and Join Our Community

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

Tags

awk, beginners, solved

Top Forums UNIX for Dummies Questions & Answers How to count no. of received data of any one files?

01-31-2015

Registered User

31, 0

Join Date: Nov 2014

Last Activity: 1 April 2016, 4:27 AM EDT

Posts: 31

Thanks Given: 16

Thanked 0 Times in 0 Posts

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.

aaditya321

View Public Profile for aaditya321

Find all posts by aaditya321

01-31-2015

Moderator

12,296, 3,792

Join Date: Nov 2008

Last Activity: 1 January 2021, 1:47 AM EST

Location: Amsterdam

Posts: 12,296

Thanks Given: 679

Thanked 3,792 Times in 3,282 Posts

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.

Scrutinizer

View Public Profile for Scrutinizer

Find all posts by Scrutinizer

01-31-2015

Registered User

31, 0

Join Date: Nov 2014

Last Activity: 1 April 2016, 4:27 AM EDT

Posts: 31

Thanks Given: 16

Thanked 0 Times in 0 Posts

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

aaditya321

View Public Profile for aaditya321

Find all posts by aaditya321

01-31-2015

Moderator

3,105, 1,603

Join Date: May 2013

Last Activity: 31 August 2020, 1:46 AM EDT

Location: Chennai

Posts: 3,105

Thanks Given: 1,269

Thanked 1,603 Times in 1,369 Posts

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:

RavinderSingh13

View Public Profile for RavinderSingh13

Find all posts by RavinderSingh13

01-31-2015

Registered User

31, 0

Join Date: Nov 2014

Last Activity: 1 April 2016, 4:27 AM EDT

Posts: 31

Thanks Given: 16

Thanked 0 Times in 0 Posts

Thanks a lot R Singh, please enhance your code i.e. how to work your given this code.

aaditya321

View Public Profile for aaditya321

Find all posts by aaditya321

01-31-2015

Moderator

3,105, 1,603

Join Date: May 2013

Last Activity: 31 August 2020, 1:46 AM EDT

Location: Chennai

Posts: 3,105

Thanks Given: 1,269

Thanked 1,603 Times in 1,369 Posts

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:

RavinderSingh13

View Public Profile for RavinderSingh13

Find all posts by RavinderSingh13

Login or Register to Ask a Question

Previous Thread | Next Thread

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

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

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

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

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

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

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

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

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

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

Login or Register to Ask a Question