08-16-2009
Count the repetition of a Field in File
Hi,
Thanks for keeping such a help-full platform active and live always.
I am new to this forum and to unix also.
Want to know how to count the repetition of a field in a file. Anything of awk, sed, perl, shell script, solution are welcomed.
Input File------------------
abc,12345
pqr,51223
mno,72121
stu,34567
aaa,12345
pqp,11224
plm,72121
zxy,88888
fgh,12345
jkl,88888
Output File-----------------
abc,12345,3
pqr,51223,1
mno,72121,2
stu,34567,1
aaa,12345,3
pqp,11224,1
plm,72121,2
zxy,88888,2
fgh,12345,3
jkl,88888,2
As 12345 is repeated 3 times in files as second field, so wherever it is "3" is suffixed as last field.
Thanks for the solution in advance.
Ace
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
vwait(3tcl) Tcl Built-In Commands vwait(3tcl)
__________________________________________________________________________________________________________________________________________________
NAME
vwait - Process events until a variable is written
SYNOPSIS
vwait varName
_________________________________________________________________
DESCRIPTION
This command enters the Tcl event loop to process events, blocking the application if no events are ready. It continues processing events
until some event handler sets the value of variable varName. Once varName has been set, the vwait command will return as soon as the event
handler that modified varName completes. varName must be globally scoped (either with a call to global for the varName, or with the full
namespace path specification).
In some cases the vwait command may not return immediately after varName is set. This can happen if the event handler that sets varName
does not complete immediately. For example, if an event handler sets varName and then itself calls vwait to wait for a different variable,
then it may not return for a long time. During this time the top-level vwait is blocked waiting for the event handler to complete, so it
cannot return either.
EXAMPLES
Run the event-loop continually until some event calls exit. (You can use any variable not mentioned elsewhere, but the name forever
reminds you at a glance of the intent.)
vwait forever
Wait five seconds for a connection to a server socket, otherwise close the socket and continue running the script:
# Initialise the state
after 5000 set state timeout
set server [socket -server accept 12345]
proc accept {args} {
global state connectionInfo
set state accepted
set connectionInfo $args
}
# Wait for something to happen
vwait state
# Clean up events that could have happened
close $server
after cancel set state timeout
# Do something based on how the vwait finished...
switch $state {
timeout {
puts "no connection on port 12345"
}
accepted {
puts "connection: $connectionInfo"
puts [lindex $connectionInfo 0] "Hello there!"
}
}
SEE ALSO
global(3tcl), update(3tcl)
KEYWORDS
event, variable, wait
Tcl 8.0 vwait(3tcl)