Sponsored Content
Top Forums Shell Programming and Scripting Print lines in which value in specified Col is NOT unique Post 302886028 by Akshay Hegde on Wednesday 29th of January 2014 11:58:49 AM
Old 01-29-2014
Code:
$ awk 'FNR==NR{A[$2]++;next}A[$2]>1' file file
cat big 24
cat red 63
dog big 34
fish    red 294

edit *I just see yoda's approach and mine are same
This User Gave Thanks to Akshay Hegde For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Awk to print distinct col values

Hi Guys... I am newbie to awk and would like a solution to probably one of the simple practical questions. I have a test file that goes as: 1,2,3,4,5,6 7,2,3,8,7,6 9,3,5,6,7,3 8,3,1,1,1,1 4,4,2,2,2,2 I would like to know how AWK can get me the distinct values say for eg: on col2... (22 Replies)
Discussion started by: anduzzi
22 Replies

2. Shell Programming and Scripting

Compare Tab Separated Field with AWK to all and print lines of unique fields.

Hi. I have a tab separated file that has a couple nearly identical lines. When doing: sort file | uniq > file.new It passes through the nearly identical lines because, well, they still are unique. a) I want to look only at field x for uniqueness and if the content in field x is the... (1 Reply)
Discussion started by: rocket_dog
1 Replies

3. UNIX for Advanced & Expert Users

Print line based on highest value of col (B) and repetion of values in col (A)

Hello everyone, I am writing a script to process data from the ATP world tour. I have a file which contains: t=540 y=2011 r=1 p=N409 t=540 y=2011 r=2 p=N409 t=540 y=2011 r=3 p=N409 t=540 y=2011 r=4 p=N409 t=520 y=2011 r=1 p=N409 t=520 y=2011 r=2 p=N409 t=520 y=2011 r=3 p=N409 The... (4 Replies)
Discussion started by: imahmoud
4 Replies

4. Shell Programming and Scripting

Compare multiple files and print unique lines

Hi friends, I have multiple files. For now, let's say I have two of the following style cat 1.txt cat 2.txt output.txt Please note that my files are not sorted and in the output file I need another extra column that says the file from which it is coming. I have more than 100... (19 Replies)
Discussion started by: jacobs.smith
19 Replies

5. Shell Programming and Scripting

Modifying col values based on another col

Hi, Please help with this. I have several excel files (with and .xlsx format) with 10-15 columns each. They all have the same type of data but the columns are not ordered in the same way. Here is a 3 column example. What I want to do add the alphabet from column 2 to column 3, provided... (9 Replies)
Discussion started by: newbie83
9 Replies

6. UNIX for Dummies Questions & Answers

Print unique lines without sort or unique

I would like to print unique lines without sort or unique. Unfortunately the server I am working on does not have sort or unique. I have not been able to contact the administrator of the server to ask him to add it for several weeks. (7 Replies)
Discussion started by: cokedude
7 Replies

7. Shell Programming and Scripting

Print lines that contain a value in a specific column shared by more than 1 entity in another col

I want to expand on a question that I just asked here: I want to extract only those values in Column 2 that are shared by at least 2 unique values in Column 2. Using the same input (in this case 3- tab-separated columns): waterline-n below-sheath-v 14.8097 dock-n below-sheath-v ... (2 Replies)
Discussion started by: owwow14
2 Replies

8. Emergency UNIX and Linux Support

Read values in each col starting 3rd row.Print occurrence value.

Hello Friends, Hope all are doing fine. Here is a tricky issue. my input file is like this 07 10 14 20 21 03 15 27 30 32 01 10 11 19 30 02 06 14 15 17 01 06 20 25 29 Logic: 1. Please print another column as "0-0-0-0-0" for the first and second rows. 2. Read the first column... (4 Replies)
Discussion started by: jacobs.smith
4 Replies

9. UNIX for Beginners Questions & Answers

Print lines based upon unique values in Nth field

For some reason I am having difficulty performing what should be a fairly easy task. I would like to print lines of a file that have a unique value in the first field. For example, I have a large data-set with the following excerpt: PS003,001 MZMWR/ L-DWD// * PS003,001... (4 Replies)
Discussion started by: jvoot
4 Replies

10. UNIX for Beginners Questions & Answers

Print number of lines for files in directory, also print number of unique lines

I have a directory of files, I can show the number of lines in each file and order them from lowest to highest with: wc -l *|sort 15263 Image.txt 16401 reference.txt 40459 richtexteditor.txt How can I also print the number of unique lines in each file? 15263 1401 Image.txt 16401... (15 Replies)
Discussion started by: spacegoose
15 Replies
NEWS2MAIL(8)						    InterNetNews Documentation						      NEWS2MAIL(8)

NAME
news2mail - Channel script to gateway news into e-mails SYNOPSIS
news2mail DESCRIPTION
news2mail runs as a channel process underneath innd. It is set up as channel feed in newsfeeds, with different mailing-lists as funnel entries pointing to it (see below); news2mail expects the token of an article followed by a sequence of list names. news2mail uses the configuration file pathetc/news2mail.cf to map mailing-list names to e-mail addresses. news2mail causes sendmail to queue the messages for later delivery (to avoid DOS attacks by mass postings). You must run "sendmail -q" periodically to get the queue processed. CONFIGURATION FILE
The configuration file format is simple: comments (starting with a hash sign "#") and blank lines are ignored. All other lines have two or three fields on them. The first is the list name and is what innd uses (i.e. the site field of the entry in the newsfeeds file). The second field is the actual e-mail address to send the article to. The third field is optional: it sets the envelope-from address (for instance a list member's address; if not set, it defaults to the "news" user). In e-mail messages, the To: header will have the mailing-list address (i.e. the second field). Besides, news2mail strips most article headers from the article before mailing. In newsfeeds, the channel feed should look like: news2mail!:!*:Ac,Tc,Wn*:<pathbin>/news2mail and for each mailing-list, you only have to add to newsfeeds an entry list like: list-big-red-ants/lists.ucsd.edu:!*,rec.pets.red-ants:Ap,Tm:news2mail! Please note the use of "Ap" and the exclusion of the list owner domain to protect the list from feeding back new arrivals from the list. The site name used in the newfeeds entry for a mailing-list (above "list-big-red-ants") must be the same as the first field in an entry in news2mail.cf. For instance: # Newsfeeds-name List-to-address [List-sender-address] list-big-red-ants big-red-ants@lists.ucsd.edu news+big-red-ants@local.news.server.org FILES
pathbin/news2mail The Perl program itself used to gateway news into e-mails. pathetc/news2mail.cf The configuration file which specifies the mapping to use for gatewaying. BUGS
The news2mail program is set up as a funneled channel in newsfeeds, implying multiple matches should be handled as one - and multiple matching funneled feeds will result in a single call to the script. Therefore, since only one mail is sent, crossposts are not currently properly handled as for the envelope-from address (which then defaults to the "news" user). HISTORY
news2mail was written by Brian Kantor in 1998. This man page was written by James Brister and converted to POD by Julien Elie. The third optional field in news2mail.cf was added by D. Stussy in 2008. $Id: news2mail.pod 8199 2008-11-30 13:30:47Z iulius $ SEE ALSO
innd(8), newsfeeds(5). INN 2.5.2 2009-05-21 NEWS2MAIL(8)
All times are GMT -4. The time now is 10:41 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy