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

Sponsored Content

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

11-02-2015

Registered User

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.

ElijaRajesh

View Public Profile for ElijaRajesh

Find all posts by ElijaRajesh

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 SUSE

xkbfreegeomoverlaykeys

XkbFreeGeomOverlayKeys(3)					   XKB FUNCTIONS					 XkbFreeGeomOverlayKeys(3)

NAME

       XkbFreeGeomOverlayKeys - Free keys in an overlay row

SYNOPSIS

       void XkbFreeGeomOverlayKeys (XkbRowPtr row, int first, int count, Bool free_all);

ARGUMENTS

       - row  row in which keys should be freed

       - first
	      first key to be freed

       - count
	      number of keys to be freed

       - free_all
	      True => all keys are freed

DESCRIPTION

       Xkb  provides a number of functions to allocate and free subcomponents of a keyboard geometry. Use these functions to create or modify key-
       board geometries.  Note that these functions merely allocate space for the new element(s), and it is up	to  you  to  fill  in  the  values
       explicitly  in  your  code. These allocation functions increase sz_* but never touch num_* (unless there is an allocation failure, in which
       case they reset both sz_* and num_* to zero). These functions return Success if they succeed, BadAlloc if they are  not	able  to  allocate
       space, or BadValue if a parameter is not as expected.

       If  free_all  is True, all keys are freed regardless of the value of first and count.  Otherwise, the number of keys specified by count are
       freed, beginning with the key specified by first in the specified row.

RETURN VALUES

       Success	      The XkbFreeGeomOverlayKeys function returns Success if there are no allocation or argument errors.

DIAGNOSTICS

       BadAlloc       Unable to allocate storage

       BadValue       An argument is out of range

X Version 11							   libX11 1.3.2 					 XkbFreeGeomOverlayKeys(3)

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