Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: I want count of number of records to be printed on each row.
Top Forums UNIX for Dummies Questions & Answers I want count of number of records to be printed on each row. Post 302959375 by ElijaRajesh on Monday 2nd of November 2015 01:27:40 AM
Old 11-02-2015
I want count of number of records to be printed on each row.
we want the count of number of records to be printed on each row.
For Ex:

if there are 5 records on one unique id , the count "5'' should be printed on each record in other column. Please help for this. I am using unix & Cygwin.
Below are sample records:
Code:
KCZ0650473 	9640898576	29-07-14	EESHVARAMMA  TOTADA 	
KCZ0650473 	9542742485	20-05-14	EESHWARAMMA  TOTADA 	 
KCZ0650473 	9542568725	20-05-14	EESHWARAMMA  TOTADA 	
KCZ0650473 	8466815506	12-10-13	ESWARAMMA    THOTADA 	
KCZ0650473 	8465942075	25-09-13	ESHVARAMMA   TOTADA 	
KCZ0650473 	8096056237	07-06-14	EESHVARAMMA  TOTADA 	 
KCZ0650473 	7660874881	25-12-13	EESHVARAMMA  TOTADA 	 
KCZ0650473 	7036175851	30-09-14	EESWARAMMA   TOTADA 	
LQM1848506 	9948258707	09-05-15	RAMA KRISHNA TIRUMANI 	
LQM1848506 	9912283897	08-05-15	RAMAKRISHNA  TIRIRUMANI 	
LQM1848506 	9912283867	09-05-15	RAMAKRISHNA  TIURMANI 	
LQM1848506 	9704647089	31-10-13	RAMAKRISHNA  TIRUMANI 	
LQM1848506 	9553889842	28-01-14	RAMA KRISHNA TIRUMANI 	
LQM1848506 	9542543464	06-03-14	RAMA KRISHNA TIRUMANI 	
LQM1848506 	7730838559	27-03-15	RAMAKRISHNA  TIRUMANI 	
LQM1848506 	7729868778	27-03-15	RAMAKRISHNA  TIRUMANI 	 
RGM0751099 	9951725477	18-03-15	ASHOK KUMAR  ANJINAPPA GARI 	
RGM0751099 	9951392653	18-03-15	ANJINAPPA ASHOK KUMAR  . 	
RGM0751099 	9666048729	26-03-15	ANJINAPPA GARI ASHOK KUMAR	
RGM0751099 	9505728685	08-01-15	ANJINAPPA GARI ASHOK KUMAR	 
RGM0751099 	8125249248	14-10-14	ASHOK KUMAR  ANJINAPPAGARI 	 
RGM0751099 	7842729360	12-12-13	ASHOK KUMAR  ANJINAPPA GARI 	
RGM0751099 	7095906292	29-12-14	ASHOK KUMAR  ANJINAPPA GARI 	 
RGM0751099 	7095128680	03-12-14	ASHOK KUMAR	ANJINAPPAGARI

Rajesh
Last edited by Don Cragun; 11-02-2015 at 03:02 AM.. Reason: Add CODE tags.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Count No of Records in File without counting Header and Trailer Records

I have a flat file and need to count no of records in the file less the header and the trailer record. I would appreciate any and all asistance Thanks Hadi Lalani (2 Replies)
Discussion started by: guiguy
2 Replies

2. UNIX for Dummies Questions & Answers

row count but only number part

hi i am pretty new to unix .i am ETL guy I need a unix script to take row count of a file and write it to another file the problem with wc-l is it include filename also wc -l abc.dat will give me like 1000 abc.dat i just want 1000 to be written can u just take 2 min to write a simple... (1 Reply)
Discussion started by: er_zeeshan05
1 Replies

3. Shell Programming and Scripting

count number of nonempty columns in row

Hi, Suppose i have a inputfile in csv format. How to use awk to count 'the number of nonempty columns in each row' minus one, and add the value as a new column in the end For cosmetic reason, it's even better to include a descriptive label for the last column in the first row. for... (2 Replies)
Discussion started by: grossgermany
2 Replies

4. Shell Programming and Scripting

how to add the number of row and count number of rows

Hi experts a have a very large file and I need to add two columns: the first one numbering the incidence of records and the another with the total count The input file: 21 2341 A 21 2341 A 21 2341 A 21 2341 C 21 2341 C 21 2341 C 21 2341 C 21 4567 A 21 4567 A 21 4567 C ... (6 Replies)
Discussion started by: juelillo
6 Replies

5. Shell Programming and Scripting

Count the number or row with same value in a column

This is the source file, we called it errorlist.out 196 server_a server_unix_2 CD 196 server_b server_win_1 CD 196 server_c server_win_2 CD 196 server_bd server_unix_2 CD 196 server_d server_unix_2 CD 196 server_es server_win_1 CD 196 ... (14 Replies)
Discussion started by: sQew
14 Replies

6. Shell Programming and Scripting

Counting number of records with string row delimiter

HI, i have a file like this t.txt f1|_f2|_ f1|_f2|_ f1|_f2|_ as if col delimiter is |_ and row delimiter |_\n trying to count number of records using awk $ awk 'BEGIN{FS="|_" ; RS="~~\n"} {n++}END{print n} ' t.txt 7 wondering how can i count this to 3 ? thx (9 Replies)
Discussion started by: aksforum
9 Replies

7. Solaris

[solved] lpstat count how many time printed

Hi guys! i've made a little mysql database to count how many time we print/day from a solaris server. To get to this info i use the command: lpstat -W completed|grep "date"after a few dates i've noticed that the amount of printout was everytime 500?! now the lpstat command keeps only the last... (0 Replies)
Discussion started by: beta17
0 Replies

8. Shell Programming and Scripting

Use GREP to count number of records and place it in a variable

I am trying to count the number of records from different files using grep, and then place the result in a separate variable for each file, so at the end of my shell script, I can sum all the variables and check if the number of records are equal to what I was expecting. It is weird butwc -ldoes... (2 Replies)
Discussion started by: dhruuv369
2 Replies

9. Shell Programming and Scripting

How to get row data printed in column using awk?

Hi team, I have below sample file. $ cat sample dn: MSISDN=400512345677,dc=msisdn,ou=NPSD,serv=CSPS,ou=servCommonData,dc=stc structuralObjectClass: NphData objectClass: NphData objectClass: MSISDN entryDS: 0 nodeId: 35 createTimestamp: 20170216121047Z modifyTimestamp: 20170216121047Z... (3 Replies)
Discussion started by: shanul karim
3 Replies

10. Shell Programming and Scripting

Reseting row count every given number of rows

I have a file with 48 rows. I am counting 6 rows and adding 6 to that number and repeating the operation, and then output the value in column 1. For the second column, I would like to get sort of a binary output (1s and 2s) every 3rd row. This is what I have: awk '{print ++src +... (1 Reply)
Discussion started by: Xterra
1 Replies
All times are GMT -4. The time now is 04:49 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy