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
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
LSREALM(1p)						User Contributed Perl Documentation					       LSREALM(1p)

NAME
lsrealm - List the realms in a DNSSEC-Tools realm file SYNOPSIS
lsrealm [options] <realm-files> DESCRIPTION
This script lists the contents of the specified realm files. All realm files are loaded before the output is displayed. If any realms have duplicated names, whether within one file or across multiple files, the later realm will be the one whose data are displayed. The output displayed for each realm in a realm file depends on the selected records, the selected attributes, and the selected output format. Each option in these option groups is described in detail in the next section. The three base output formats are described here. The -terse option indicates that a minimal amount of output is desired; the -long option indicates that a great deal of output is desired. The record-selection and attribute-selection options may be used in conjunction with -terse to display exactly the set of realm fields needed. The default output format is that used when neither -terse nor -long is given, and is a middle ground between terse and long output. The table below shows the fields displayed for each output format. realm field default terse long ------------- ------- ----- ---- realm name yes yes yes state yes no yes config directory no no yes realm directory no no yes rollrec file no no yes administrator no no yes directory no no yes display flag no no yes manager no no yes manager arguments no no yes user no no yes OPTIONS
There are three types of options recognized by lsrealm: record-selection options, attribute-selection options, and output-format options. Each type is described in the subsections below. Record-selection Options These options select the records that will be displayed by lsrealm. By default, all records will be displayed; selecting one or the other of these options will restrict the records shown. These options are mutually exclusive. -active List all active records in the realm file. -inactive List all inactive records in the realm file. Attribute-selection Options These options select the attributes of the records that will be displayed by lsrealm. -admin The record's administrator value is included in the output. If an administrator value is not included in a realm, then the value "(defadmin)" will be given. -args The record's user-defined arguments for the realm's rollover manager. -configdir The record's configuration directory is included in the output. This value will be the filename only, unless the -fullpaths option is given. In that case, the full pathname will be printed. -display The record's display flag, used by grandvizier is included in the output. -manager The record's manager field, indicating which rollover manager is used for the realm.. The default is rollerd, but individual installations may use other managers. -realmdir The record's realm directory is included in the output. This value will be the filename only, unless the -fullpaths option is given. In that case, the full pathname will be printed. -rollrec The record's rollrec file is included in the output. This value will be the filename only, unless the -fullpaths option is given. In that case, the full pathname will be printed. -state Include each realm record's state in the output. The state will be either "active" or "inactive". This field is part of the default output. -user The record's user field, which is the user the realm's manager will be executed with. This field is not yet implemented. Output-format Options These options select the type of output that will be given by lsrealm. -count Only a count of matching realms in the realm file is given. -fullpaths Display pathname data as the full pathname given in the realm file. If this option is not specified, only the filename itself will be displayed. -headers Display explanatory column headers. -terse Terse output is given. Only the record name and any other fields specifically selected are included in the output. -long Long output is given. All record fields are included. -help Display a usage message. -Version Displays the version information for lsrealm and the DNSSEC-Tools package. COPYRIGHT
Copyright 2012 SPARTA, Inc. All rights reserved. See the COPYING file included with the DNSSEC-Tools package for details. AUTHOR
Wayne Morrison, tewok@tislabs.com SEE ALSO
dtrealms(8), grandvizier(8), realminit(8) Net::DNS::SEC::Tools::realm.pm(3) file-realm(5) perl v5.14.2 2012-06-21 LSREALM(1p)
All times are GMT -4. The time now is 09:55 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy