How to grep/awk only particular field?

Login or Register to Ask a Question and Join Our Community

How to grep/awk only particular field?

Login to Discuss or Reply to this Discussion in Our Community

Top Forums UNIX for Beginners Questions & Answers How to grep/awk only particular field?

04-09-2017

Registered User

37, 1

Join Date: Dec 2011

Last Activity: 10 April 2017, 1:45 AM EDT

Posts: 37

Thanks Given: 13

Thanked 1 Time in 1 Post

How to grep/awk only particular field?

I have a file like this. I want to filter values for only the particular day.

Source file:

Code:

# cat /tmp/1
Name  Mon Tue Wed Thu Fri Sat Sun
A      Y
B          Y
C                      Y
D                              Y
F      Y
G                   Y      Y
#

For ex:
I want to select only monday list. But if i use awk command like below it is selecting the 1st and second field. But for the second field it is selecting from all the rows.

Code:

cat /tmp/1|awk '{print $1,$2}'
Name Mon
A Y
B Y
C Y
D Y
F Y
G Y

Output should be:
For Monday:

Code:

Name  Mon
A      Y
F      Y

For Tuesday:

Code:

Name Tue
B     Y

Like this i want to filter for all the days. Please help.

thomasraj87

View Public Profile for thomasraj87

Find all posts by thomasraj87

04-10-2017

Moderator

12,296, 3,792

Join Date: Nov 2008

Last Activity: 1 January 2021, 1:47 AM EST

Location: Amsterdam

Posts: 12,296

Thanks Given: 679

Thanked 3,792 Times in 3,282 Posts

With GNU awk 4 you can do this:

Code:

$ awk -v wd=2 '$wd~/[^ ]/{print $1, $wd}' FIELDWIDTHS="6 4 4 4 4 4 4" file
Name   Mon 
A       Y
F       Y
$ awk -v wd=3 '$wd~/[^ ]/{print $1, $wd}' FIELDWIDTHS="6 4 4 4 4 4 4" file
Name   Tue 
B       Y
$ awk -v wd=6 '$wd~/[^ ]/{print $1, $wd}' FIELDWIDTHS="6 4 4 4 4 4 4" file
Name   Fri 
C       Y

This User Gave Thanks to Scrutinizer For This Post:

Scrutinizer

View Public Profile for Scrutinizer

Find all posts by Scrutinizer

04-10-2017

Registered User

37, 1

Join Date: Dec 2011

Last Activity: 10 April 2017, 1:45 AM EDT

Posts: 37

Thanks Given: 13

Thanked 1 Time in 1 Post

Thanks Scrutinizer. It works perfectly.

thomasraj87

View Public Profile for thomasraj87

Find all posts by thomasraj87

04-10-2017

Registered User

2,288, 480

Join Date: Apr 2007

Last Activity: 3 May 2020, 8:28 AM EDT

Location: Saint Paul, MN USA / BSD, CentOS, Debian, OS X, Solaris

Posts: 2,288

Thanks Given: 430

Thanked 480 Times in 395 Posts

Hi.

See also post #11 in thread Getting the lines with nth column non-null

It demonstrates a perl-based utility, colgrep, part of a collection of such utilities written in perl.

In your specific case, you would need to do extra work, such as formatting the input file using TABs, which could be more trouble than it is worth.

Best wishes ... cheers, drl

drl

View Public Profile for drl

Find all posts by drl

04-13-2017

Registered User

15,129, 5,008

Join Date: Jul 2012

Last Activity: 4 May 2020, 4:31 PM EDT

Location: Aachen, Germany

Posts: 15,129

Thanks Given: 735

Thanked 5,008 Times in 4,483 Posts

Would this do ( it won't work with two "Y" s in a row):

Code:

awk 'NR == 1 || (length()/4) == 2' file
Name  Mon Tue Wed Thu Fri Sat Sun
A      Y
F      Y

RudiC

View Public Profile for RudiC

Find all posts by RudiC

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Problem with getting awk to multiply a field by a value set based on condition of another field

Hi, So awk is driving me crazy on this one. I have searched everywhere and read man, docs and every related post Google can find and still no luck. The actual files I need to run this on are sensitive in nature, but it is the same thing as if I needed to calculate weighted grades for multiple...

2. Shell Programming and Scripting

awk to update field using matching value in file1 and substring in field in file2

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 ;...

3. Shell Programming and Scripting

awk to adjust coordinates in field based on sequential numbers in another field

I am trying to output a tab-delimited result that uses the data from a tab-delimited file to combine and subtract specific lines. If $4 matches in each line then the first matching sequential $6 value is added to $2, unless the value is 1, then the original $2 is used (like in the case of line...

4. Shell Programming and Scripting

How can awk ignore the field delimiter like comma inside a field?

We have a csv file as mentioned below and the requirement is to change the date format in file as mentioned below. Current file (file.csv) ---------------------- empname,date_of_join,dept,date_of_resignation ram,08/09/2015,sales,21/06/2016 "akash,sahu",08/10/2015,IT,21/07/2016 ...

5. Shell Programming and Scripting

awk to parse field and include the text of 1 pipe in field 4

I am trying to parse the input in awk to include the |gc= in $4 but am not able to. The below is close: awk so far: awk '{sub(/\|]+]++/, ""); print }' input.txt Input chr1 955543 955763 AGRN-6|pr=2|gc=75 0 + chr1 957571 957852 AGRN-7|pr=3|gc=61.2 0 + chr1 970621 ...

6. Shell Programming and Scripting

awk repeat one field at all lines and modify field repetitions

Hello experts I have a file with paragraphs begining with a keeping date and ending with "END": 20120301 num num John num num A keepnum1 num num kathrin num num A keepnum1 num num kathrin num num B keepnum2 num num Pete num num A keepnum1 num num Jacob num...

7. Shell Programming and Scripting

AWK: Pattern match between 2 files, then compare a field in file1 as > or < field in file2

First, thanks for the help in previous posts... couldn't have gotten where I am now without it! So here is what I have, I use AWK to match $1 and $2 as 1 string in file1 to $1 and $2 as 1 string in file2. Now I'm wondering if I can extend this AWK command to incorporate the following: If $1...

8. Shell Programming and Scripting

Awk Search text string in field, not all in field.

Hello, I am using awk to match text in a tab separated field and am able to do so when matching the exact word. My problem is that I would like to match any sequence of text in the tab-separated field without having to match it all. Any help will be appreciated. Please see the code below. awk...

9. Shell Programming and Scripting

awk, comma as field separator and text inside double quotes as a field.

Hi, all I need to get fields in a line that are separated by commas, some of the fields are enclosed with double quotes, and they are supposed to be treated as a single field even if there are commas inside the quotes. sample input: for this line, 5 fields are supposed to be extracted, they...

10. Shell Programming and Scripting

Moving Part of a field to another field using AWK

Hi there, I have a comma seperated file with nine fields the fields are rerate: "numberTX",field2,field3,field4,field5..... I want to do this to the file reate: "field5TX",field2,field3,field4,field5 I know I can do this using AWK, but the thing giving me fits is that I...

Login or Register to Ask a Question