I want count of number of records to be printed on each row. Post: 302959378

Sponsored Content

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

11-02-2015

Registered User

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

shekhar_4_u

View Public Profile for shekhar_4_u

Find all posts by shekhar_4_u

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

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

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

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

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

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

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

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

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

LEARN ABOUT REDHAT

amdd

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

NAME

       amdd - Amanda version of dd

SYNOPSIS

       amdd [ -d ] [ if=input ] [ of=output ] [ bs=blocksize ] [ skip=count ] [ count=count ]

DESCRIPTION

       Amdd  provides just enough of the standard dd command for the needs of Amanda.  This is handy when doing a full restore and the standard dd
       program has not yet been found.

       Amdd also provides access to the Amanda output drivers that support various tape simulations.  This may be used for debugging or to convert
       from one format to another.

       See  the  amanda(8) man page for more details about Amanda.  See the OUTPUT DRIVERS section of amanda(8) for more information on the Amanda
       output drivers.

OPTIONS

       -d     Turn on debugging output.

       -llength
	      Set the output length.  If the output driver limits the output size, this controls when end of tape will be simulated.

	      Length may have a multiplier suffix:

		     k 1024 (Kilobytes)

		     b 512 (Blocks)

		     M 1024*1024 (Megabytes)

	      The default is no multipler (bytes).

       if=input
	      Input to dd.  Default is stdin.

       of=output
	      Where to send the output of dd.  Default is stdout.

       bs=blocksize
	      Size of each record.  Input records smaller than this will not be padded.  Output records will be the same size as the corresponding
	      input record.  Default is 512 bytes.

	      Blocksize may have a multiplier suffix:

		     k 1024 (Kilobytes)

		     b 512 (Blocks)

		     M 1024*1024 (Megabytes)

	      The default is no multipler (bytes).

       count=count
	      Number of records to copy.  Default is all records until end of file.

       skip=count
	      Number of records to skip before copying input to output.  Default is zero.

AUTHOR

       Marc Mengel <mengel@fnal.gov>
       John R. Jackson <jrj@purdue.edu>

SEE ALSO

       amanda(8)

																	   AMDD(8)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

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

Discussion started by: guiguy

2. UNIX for Dummies Questions & Answers

row count but only number part

Discussion started by: er_zeeshan05

3. Shell Programming and Scripting

count number of nonempty columns in row

Discussion started by: grossgermany

4. Shell Programming and Scripting

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

Discussion started by: juelillo