|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Count the repetition of a Field in File
Post 302344572 by indian.ace on Monday 17th of August 2009 05:05:36 AM
08-17-2009
Franklin,This is what i am getting, as you know much more abt this you can find out if I am doing something wrong I have Solaris10 as OS.
root@sunmc01>cat file
abc,12345
pqr,51223
mno,72121
stu,34567
aaa,12345
pqp,11224
plm,72121
zxy,88888
fgh,12345
jkl,88888
root@sunmc01>awk -F, 'NR==FNR{a[$2]++;next}{print $0 "," a[$2]}' file file
abc,12345,
pqr,51223,
mno,72121,
stu,34567,
aaa,12345,
pqp,11224,
plm,72121,
zxy,88888,
fgh,12345,
jkl,88888,
abc,12345,
pqr,51223,
mno,72121,
stu,34567,
aaa,12345,
pqp,11224,
plm,72121,
zxy,88888,
fgh,12345,
jkl,88888,
root@sunmc01>
Thanks for your consistent support.
root@sunmc01>cat file
abc,12345
pqr,51223
mno,72121
stu,34567
aaa,12345
pqp,11224
plm,72121
zxy,88888
fgh,12345
jkl,88888
root@sunmc01>awk -F, 'NR==FNR{a[$2]++;next}{print $0 "," a[$2]}' file file
abc,12345,
pqr,51223,
mno,72121,
stu,34567,
aaa,12345,
pqp,11224,
plm,72121,
zxy,88888,
fgh,12345,
jkl,88888,
abc,12345,
pqr,51223,
mno,72121,
stu,34567,
aaa,12345,
pqp,11224,
plm,72121,
zxy,88888,
fgh,12345,
jkl,88888,
root@sunmc01>
Thanks for your consistent support.
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi Guys,
I wanted to count the number of records for a particular field of a file. whose fields are separated by comma","
I fI use this command.
cat "filename" cut -sd "," -f13 | wc -l
This shows all the lines count including the blank values for the field number 13. I wanted to count... (2 Replies)
Discussion started by: Swapna173
2 Replies
2. Shell Programming and Scripting
I have a large file with fields delimited by '|', and I want to run some analysis on it. What I want to do is count how many times each field is populated, or list the frequency of population for each field.
I am in a Sun OS environment.
Thanks,
- CB (3 Replies)
Discussion started by: ChicagoBlues
3 Replies
3. Shell Programming and Scripting
Hi all,
I have a scenario, like consider a file abc.txt,
inside abc.txt, the contents is
value1 = aaa,
value2 = bbb,
value3 = ccc,
value1 = ddd.
In this situation i need to throw an error for the repeatation of keys like "value1" is repeating twice.
how to handle this using bourne... (1 Reply)
Discussion started by: Nandagopal
1 Replies
4. Shell Programming and Scripting
Hello,
I have a text file with n lines in the following format (9 column fields):
Example:
contig00012 149606 G C 49 68 60 18 c$cccccacccccccccc^c
I need to count the number of lower-case and upper-case occurences in column 9, respectively, of the... (3 Replies)
Discussion started by: s052866
3 Replies
5. Shell Programming and Scripting
Hi Mates,
I require help in the following:
I have the following file snmp.txt
Wed Mar 2 16:02:39 SGT 2011
Class : mmTrapBladeS
origin : 10.0.0.0
hostname : 10.0.0.2
msg : IBM Blade Alert:
Calendar Index : 10.0.0.2-IBMBLADE
Fri Mar 4 07:10:54 SGT 2011
Class : mmTrapBladeS... (2 Replies)
Discussion started by: dbashyam
2 Replies
6. Shell Programming and Scripting
Hello,
I am using Awk in UBUNTU 12.04.
I have a file as following with 48,432,354 lines and 4 fields.
The file has this structure (There are repetitions of the first column in several lines)
AB_14 S54 A G
AB_14 S55 A A
AB_14 S56 G G
GO_15 S45 T A
GO_15 S46 A A
PT_16 S33 C C
PT_16 ... (4 Replies)
Discussion started by: Homa
4 Replies
7. Shell Programming and Scripting
Hi I have a file with contents like :
101,6789556897,0000795369 - seq - fmt_recs187] - avg_recs
101,4678354769,0000835783 - seq - fmt_recs98] - avg_recs
221,5679787008,0001344589 - seq - fmt_recs1283] - avg_recs
I need to find the sum of the all the values (which are in bold).
here... (6 Replies)
Discussion started by: rkrish
6 Replies
8. Shell Programming and Scripting
When I use the below awk to count the unique lines in $4 for the input it seems to work. The answer is 3 because $4 is only unique 3 times in all the entries. However, when I use the same on actual data I get 56,536 and I know the answer should be 56,548. My question is there a better way to... (8 Replies)
Discussion started by: cmccabe
8 Replies
9. Shell Programming and Scripting
Example i have 3 fields and i wanna add my input to the field after that (NF+1)
SID|Fname|Lname
123123:adds:asdasdasd
Result
SID|Fname|Lname|Number
123123:adds:asdasdasd:123123
---------- Post updated at 02:36 PM ---------- Previous update was at 02:23 PM ----------
Input is likes.... (3 Replies)
Discussion started by: vutung1991
3 Replies
10. UNIX for Beginners Questions & Answers
Hi,
Sure it's an easy one, but it drives me insane.
input ("|" separated):
1|A,B,C,A
2|A,D,D
3|A,B,B
I would like to count the occurence of each capital letters in $2 across the entire file, knowing that duplicates in each record count as 1.
I am trying to get this output... (5 Replies)
Discussion started by: beca123456
5 Replies
LEARN ABOUT MINIX
pbmupc
pbmupc(1) General Commands Manual pbmupc(1) NAME
pbmupc - create a Universal Product Code bitmap SYNOPSIS
pbmupc [-s1|-s2] type manufac product DESCRIPTION
Generates a Universal Product Code symbol. The three arguments are: a one digit product type, a five digit manufacturer code, and a five digit product code. For example, "0 72890 00011" is the code for Heineken. As presently configured, pbmupc produces a bitmap 230 bits wide and 175 bits high. The size can be altered by changing the defines at the beginning of the program, or by running the output through pnmenlarge or pnmscale. OPTIONS
The -s1 and -s2 flags select the style of UPC to generate. The default, -s1, looks more or less like this: |||||||||||||||| |||||||||||||||| |||||||||||||||| |||||||||||||||| 0||12345||67890||5 The other style, -s2, puts the product type digit higher up, and doesn't display the checksum digit: |||||||||||||||| |||||||||||||||| 0|||||||||||||||| |||||||||||||||| ||12345||67890|| SEE ALSO
pbm(5) AUTHOR
Copyright (C) 1989 by Jef Poskanzer. 14 March 1989 pbmupc(1)