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 302959381 by Don Cragun on Monday 2nd of November 2015 03:43:37 AM
Old 11-02-2015
Now that CODE tags have been added to your post, we can see that, except for the last line, each line has four fields separated by a <space> and a <tab> (between the 1st two fields) and just separated by a <tab> (between the 2nd and 3rd field and between the 3rd and 4th field). The last line has an additional <tab> separated field.

You have not given us any indication of which field (or combination of fields) constitutes the unique id that you're trying to count. You have not described whether you just want to print the unique ids and the counts or if you want to print the original input with an additional field with an added count field. (And, if it is the latter, we don't know if you want a running count of the number of times that unique id has appeared in the file to that point or if you want each line to have the number of times the unique id on that line appears anywhere in the file.)
  1. Please use CODE tags when displaying sample input, sample output, and code segments.
  2. Please tell us which UNIX operating system (or operating systems) you are using in addition to using Cygwin on a Windows operating system.
  3. Please tell us if your input file(s) are UNIX/Linux format text files or DOS/Windows format text file?
  4. Please explain what in your input file(s) is the unique id.
  5. Please explain clearly what output you are trying to produce.
  6. Please show us the output you are hoping to produce from the sample input you provided in post #1 in this thread.
  7. Please tell us what shell you are using.
  8. Please show us the code that you have written to try to solve this problem.
 

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 X11R4

xkbfreegeomoverlaykeys

XkbFreeGeomOverlayKeys(3)					   XKB FUNCTIONS					 XkbFreeGeomOverlayKeys(3)

NAME

       XkbFreeGeomOverlayKeys - Free keys in an overlay row

SYNOPSIS

       void XkbFreeGeomOverlayKeys ( row, first, count, free_all )
	     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.2.1 					 XkbFreeGeomOverlayKeys(3)
All times are GMT -4. The time now is 09:15 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy