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 302959378 by shekhar_4_u on Monday 2nd of November 2015 01:52:10 AM
Old 11-02-2015
Quote:
Originally Posted by ElijaRajesh
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:
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

Please try this:

Code:
awk '
{
  for (i=1; i<=NR; i++)
{ 
print $0 " " NF
}
}' unix.txt

 

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

LEARN ABOUT DEBIAN

uptimed

UPTIMED(8)						      System Manager's Manual							UPTIMED(8)

NAME

       uptimed - daemon to record uptime records

SYNOPSIS

       uptimed [ -?bv ] [ -e <email> ] [ -i <interval> ] [ -m <count> ]

DESCRIPTION

       This manual page documents the uptimed program.

       uptimed is a daemon that records statistics about a machine's uptime. Use the uprecords(1) program to get uptime record statistics.

OPTIONS

       These command-line options override settings in the configuration file /etc/uptimed.conf

       -?     Show usage

       -b     Create bootid and exit. This option is ignored on BSD systems, because the BSD kernel keeps a static boot time variable in memory so
	      Uptimed does not need to cache this value.

       -p <file>
	      Write PID to pidfile <file>

       -e <email>
	      Send mail to <email> at milestones/records

       -i <interval>
	      Use <interval> seconds for loop

       -m <count>
	      Log a maximum of <count> entries

       -t <timespec>
	      Set the minimum uptime to be considered a record

       -v     Show version information

SEE ALSO

       uprecords(1)

AUTHOR

       Rob Kaper <cap@capsi.com>.

       This manual page was written by Alan Ford <alan@whirlnet.co.uk>, for the Debian GNU/Linux system (but may be used by others). It  was  last
       modified for uptimed version 0.3.7.

								   May 28, 2004 							UPTIMED(8)
All times are GMT -4. The time now is 05:04 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy