05-13-2014
Thanks vgersh99!
Hope I did not offend you or hurt your feeling when I said your script took ~45hours to process my data. Originally I was thinking the scenario for one column comparison of substrings, then the two-columns situation (to handle array in awk which I did not catch well), which should be a new post. But I knew there are many experts in this forum, and I just posted it when the question popped up my mind. Sometime I felt guilty that you guys helped me so much but I did nothing. And my learning seems very slow.
Thank you!
Last edited by yifangt; 05-13-2014 at 04:42 PM..
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi all,
I have a file that contains a list of codes (shown below).
I want to 'uniq' the file using only the first field. Anyone know an easy way of doing it?
Cheers,
Dave
##### Input File #####
1xr1 1xws 1yxt 1yxu 1yxv 1yxx 2o3p 2o63 2o64 2o65
1xr1 1xws 1yxt 1yxv 1yxx 2o3p 2o63 2o64... (8 Replies)
Discussion started by: Digby
8 Replies
2. UNIX for Dummies Questions & Answers
Hi ;
I have a question regarding the uniq command in unix
How do I uniq 3rd field in a file ?
original file :
zoom coord 39 18652 39 18652
zoom coord 39 18653 39 18653
zoom coord 39 18818 39 18818
zoom coord 39 18840 39 18840
zoom coord 41 15096 41 15096
zoom... (1 Reply)
Discussion started by: babycakes
1 Replies
3. Shell Programming and Scripting
How can I use uniq on a certain field or what else could I use? If I want to use uniq on the second field and the output would remove one of the lines with a 5.
bob 5 hand
jane 3 leg
jon 4 head
chris 5 lungs (1 Reply)
Discussion started by: Bandit390
1 Replies
4. Shell Programming and Scripting
Anyone can help for filter the uniq record for below example? Thank you very much
Input file
20090503011111|test|abc
20090503011112|tet1|abc|def
20090503011112|test1|bcd|def
20090503011131|abc|abc
20090503011131|bbc|bcd
20090503011152|bcd|abc
20090503011151|abc|abc... (8 Replies)
Discussion started by: bleach8578
8 Replies
5. Shell Programming and Scripting
Hi New to unix.
I want to display only the unrepeated lines from a file using first field.
Ex:
1234 uname1 status1
1235 uname2 status2
1234 uname3 status3
1236 uname5 status5
I used
sort filename | uniq -u
output:
1234 uname1 status1
1235 uname2 status2
1234 uname3 status3
1236... (10 Replies)
Discussion started by: venummca
10 Replies
6. Shell Programming and Scripting
I have a flatfile A.txt
2012/12/04 14:06:07 |trees|Boards 2, 3|denver|mekong|mekong12
2012/12/04 17:07:22 |trees|Boards 2, 3|denver|mekong|mekong12
2012/12/04 17:13:27 |trees|Boards 2, 3|denver|mekong|mekong12
2012/12/04 14:07:39 |rain|Boards 1|tampa|merced|merced11
How do i sort and get... (3 Replies)
Discussion started by: sabercats
3 Replies
7. Shell Programming and Scripting
Hi All,
I am searching for a script which will produce an output file with the uniq first field with the second field having highest value among all the duplicates..
The output file will produce only the uniqs which are duplicate 3 times..
Input file
X 9
B 5
A 1
Z 9
T 4
C 9
A 4... (13 Replies)
Discussion started by: ailnilanjan
13 Replies
8. Shell Programming and Scripting
Hii,
I am reading data from files by defining path as *.log etc,
Files names are like app1a_test2_heep.log , cdc2a_test3_heep.log etc
How to configure logstash so that the part of string that is string before underscore (app1a, cdc2a..) should be grepped and added to host field and... (7 Replies)
Discussion started by: Ravi Kishore
7 Replies
9. Shell Programming and Scripting
Hi All,
I am trying to output uniq values per column. see file below. can you please assist? Thank you in advance.
cat names
joe allen ibm
joe smith ibm
joe allen google
joe smith google
rachel allen google
desired output is:
joe allen google
rachel smith ibm (5 Replies)
Discussion started by: Apollo
5 Replies
10. Shell Programming and Scripting
In the awk below I am trying to set/update the value of $14 in file2 in
bold, using the matching NM_ in $12 or $9 in file2
with the NM_ in $2 of file1.
The lengths of $9 and $12 can be variable but what is consistent is the start pattern
will always be NM_ and the end pattern is always ;... (2 Replies)
Discussion started by: cmccabe
2 Replies
LEARN ABOUT HPUX
postwait
postwait(2) System Calls Manual postwait(2)
NAME
postwait: pw_getukid(), pw_wait(), pw_post(), pw_postv(), pw_getvmax() - lightweight synchronization mechanism
SYNOPSIS
DESCRIPTION
Postwait is a fast, lightweight sleep/wakeup mechanism that can be used for synchronization by cooperating kernel threads within a single
process or between separate processes.
A thread calls to block. It resumes execution when it is posted by another thread, the call expires, or is signaled. If one or more posts
are already pending, returns immediately.
Threads using postwait are identified by their ukid. A thread retrieves its ukid by calling It shares this ukid with anyone it chooses by
any means it considers appropriate (for example, shared memory).
is called with a timeout ts. If ts is NULL, the thread will not timeout. It will remain blocked until posted or a signal wakes it up.
If ts points to a zero-valued timespec, will return immediately with a value (and indicating whether or not it was posted.
If ts points to a timespec whose value is greater than zero, the thread will block for that amount of time unless it is posted or inter-
rupted by a signal, in which case the timespec pointed to by ts is updated with the remaining time. The return value and are set to indi-
cate the reason the call returned.
is used to post many threads with a single call. It posts to all threads in the targets array. An value for each target is returned in
the errors array. (0 indicates success.) If the errors pointer is zero, no target-specific errors are copied out.
There is a maximum number of threads that can be posted with a single call. This value is returned by
Posts sent to a kernel thread that already has a post pending against it are discarded.
RETURN VALUE
returns 0 if it succeeds, -1 otherwise.
returns 0 if posted, -1 otherwise.
returns 0 if the post succeeds, -1 otherwise.
returns 0 if every post succeeds, -1 otherwise.
returns the maximum number of kernel threads that can be posted with a single call to
ERRORS
sets to one of the following values if it fails:
ukid points to an illegal address. The reliable detection of this error is implementation dependent.
sets to one of the following values if it fails:
was called with a timeout of 0 but the caller has no post(s) pending.
was called with a timeout that expired.
ts points to an illegal address. The reliable detection of this error is implementation dependent.
was interrupted
by a signal.
The timespec pointed to by ts is invalid.
sets to one of the following values if it fails:
The ukid refers to a non-existent kernel thread.
sets to one of the following values if it fails:
targets points to an illegal address. The reliable detection of this error is implementation dependent.
errors points to an illegal address. The reliable detection of this error is implementation dependent.
count is less than 0.
count exceeds the maximum value (as returned by
A ukid refers to a non-existent kernel thread.
postwait(2)