How to print line if field matches?

Login or Register to Ask a Question and Join Our Community

How to print line if field matches?

Tags

Login to Discuss or Reply to this Discussion in Our Community

Top Forums Shell Programming and Scripting How to print line if field matches?

09-02-2010

Registered User

62, 0

Join Date: Jul 2009

Last Activity: 25 July 2020, 9:51 AM EDT

Posts: 62

Thanks Given: 8

Thanked 0 Times in 0 Posts

How to print line if field matches?

Hi all,

I got several lines line this
a b c d e 1 e
a 1 c d e 3 f
a b c 1 e 8 h
a b c d e 1 w
a 1 c d e 2 w
a b c d e 1 t
a b c d e 7 4

How can I print the line if 1 is the field one before the last field?
Basicly this 2 field ?
a b c d e 1 e
a b c d e 1 t

The file I got is huges.

Thanks

stinkefisch

View Public Profile for stinkefisch

Find all posts by stinkefisch

09-02-2010

Registered User

298, 4

Join Date: Nov 2009

Last Activity: 3 February 2019, 6:32 PM EST

Location: india

Posts: 298

Thanks Given: 3

Thanked 4 Times in 4 Posts

Quote:

Originally Posted by stinkefisch

Hi all,

I got several lines line this
a b c d e 1 e
a 1 c d e 3 f
a b c 1 e 8 h
a b c d e 1 w
a 1 c d e 2 w
a b c d e 1 t
a b c d e 7 4

How can I print the line if 1 is the field one before the last field?
Basicly this 2 field ?
a b c d e 1 e
a b c d e 1 t

The file I got is huges.

Thanks

Try this

Code:

awk '$(NF-1)=="1"' file

Regards,
Gaurav.

gaurav1086

View Public Profile for gaurav1086

Find all posts by gaurav1086

09-02-2010

Registered User

2,163, 123

Join Date: Nov 2007

Last Activity: 31 July 2016, 9:42 AM EDT

Location: H3X

Posts: 2,163

Thanks Given: 11

Thanked 123 Times in 116 Posts

Code:

awk '!($(NF-1)-1)' file

danmero

View Public Profile for danmero

Find all posts by danmero

09-03-2010

Registered User

2,759, 420

Join Date: Jun 2006

Last Activity: 13 September 2015, 8:58 PM EDT

Posts: 2,759

Thanks Given: 44

Thanked 420 Times in 408 Posts

Only for this special sample input.

Code:

grep "1..$" infile

rdcwayx

View Public Profile for rdcwayx

Find all posts by rdcwayx

09-03-2010

Registered User

2,163, 123

Join Date: Nov 2007

Last Activity: 31 July 2016, 9:42 AM EDT

Location: H3X

Posts: 2,163

Thanks Given: 11

Thanked 123 Times in 116 Posts

Quote:

Originally Posted by rdcwayx

Only for this special sample input.

Code:

grep "1..$" infile

Can we remove the quotes ? will be shorter

danmero

View Public Profile for danmero

Find all posts by danmero

09-03-2010

Registered User

1,713, 295

Join Date: Feb 2010

Last Activity: 26 April 2017, 8:59 AM EDT

Location: istanbul

Posts: 1,713

Thanks Given: 4

Thanked 295 Times in 286 Posts

Code:

# sed -e 'N;h' -e 's/. . . . . \(.\) .\n. . . . . \(.\) .*$/\1\2/' -e '/1$/x;s/.*\n\(.*\)/\1/' -e '/^1/x;s/\(.*\)\n.*/\1/' infile \
> |sed -e '$h' -e '/. . . . . \(.\) .\1/x;!s/11.*//' -e '/^$/d' -e '/^[^1]*$/d'
a b c d e 1 e
a b c d e 1 w
a b c d e 1 t

Code:

# cat infile
a b c d e 1 e
a 1 c d e 3 f
a b c 1 e 8 h
a b c d e 1 w
a 1 c d e 2 w
a b c d e 1 t
a b c d e 7 4

ygemici

View Public Profile for ygemici

Find all posts by ygemici

09-03-2010

Registered User

194, 3

Join Date: Aug 2009

Last Activity: 23 September 2017, 9:52 AM EDT

Location: Dhaka,Bangladesh

Posts: 194

Thanks Given: 38

Thanked 3 Times in 3 Posts

Quote:

Originally Posted by stinkefisch

Hi all,

I got several lines line this
a b c d e 1 e
a 1 c d e 3 f
a b c 1 e 8 h
a b c d e 1 w
a 1 c d e 2 w
a b c d e 1 t
a b c d e 7 4

How can I print the line if 1 is the field one before the last field?
Basicly this 2 field ?
a b c d e 1 e
a b c d e 1 t

The file I got is huges.

Thanks

Read this 8 Powerful Awk Built-in Variables – FS, OFS, RS, ORS, NR, NF, FILENAME, FNR (link removed) for NF,NR etc.

cola

View Public Profile for cola

Find all posts by cola

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Print line if values in fields matches number and text

datafile: 2017-03-24 10:26:22.098566|5|'No Route for Sndr:RETEK RMS 00040 /ZZ Appl:PF Func:PD Txn:832 Group Cntr:None ISA CntlNr:None Ver:003050 '|'2'|'PFI'|'-'|'EAI_ED_DeleteAll'|'EAI_ED'|NULL|NULL|NULL|139050594|ActivityLog| 2017-03-27 02:50:02.028706|5|'No Route for...

2. Shell Programming and Scripting

Print whole line if variables matches

Der colleagues, 4 days I am trying to solve my issue and no success.. Maybe you can give me a clue how to achieve what I need.. So I have two files. file1 example: 1_column1.1 1_column2.1 aaa 1_column4.1 1_column1.2 1_column2.2 ttt 1_column4.2 1_column1.3 1_column2.3 ...

3. Linux

Print line 1 if line 3 matches of the output

Hi I want to extend following command so that on the basis of "Branch: ****" on the third line I can grep and print name of the file on the first line. cat .labellog.emd | grep DA2458A7962276A7E040E50A0DC06459 | cut -d " " -f2 | grep -v branch_name | xargs -I file <command to describe> file ...

4. Shell Programming and Scripting

How to print line if two lines above it matches patterns.?

Hi, I could only find examples to print line before/after a match, but I'd need to print line after two separate lines matching. E.g.: From the below log entry, I would need to print out the 1234. This is from a huge log file, that has a lot of entries with "CLIENT" and "No" entries (+ other...

5. Shell Programming and Scripting

Command/script to match a field and print the next field of each line in a file.

Hello, I have a text file in the below format: Source Destination State Lag Status CQA02W2K12pl:D:\CAQA ...

6. Shell Programming and Scripting

awk to print the line that matches and the next if line is wrapped

I have a file and when I match the word "initiators" in the first column I need to be able to print the rest of the columns in that row. This is fine for the most part but on occasion the "initiators" line gets wrapped to the next line. Here is a sample of the file. caw-enabled ...

7. Shell Programming and Scripting

Using regex's from file1, print line and line after matches in file2

Good day, I have a list of regular expressions in file1. For each match in file2, print the containing line and the line after. file1: file2: Output: I can match a regex and print the line and line after awk '{lines = $0} /Macrosiphum_rosae/ {print lines ; print lines } ' ...

8. UNIX for Advanced & Expert Users

Print line if subsrt matches array

Hi Folks! im printing all lines where the characters in position 270-271 match 33|H1|HA|KA|26 so i came up with this #!/bin/bash array=(33 H1 HA KA 26 ) for i in "${array}" do #echo $i awk '{ if (substr($0,270,2)~'/$i/') print; }' $1 >> $1.temp done It works fine . but...

9. Shell Programming and Scripting

Print line if first Field matches a pattern

Hi All, I would like my code to be able to print out the whole line if 1st field has a dot in the number. Sample input and expected output given below. My AWK code is below but it can;t work, can any expert help me ? Thanks in advance. {if ($1 ~ /*\.*/) { print $0 }} Input: ...

10. Shell Programming and Scripting

print next line if matches a particular word..need help

Hi i need a help for making a script whch can print next line if it matches a particular word like file1 have ename Mohan eid 2008 ename Shyam eid 345 if scipt got Mohan it will print next line (eid 2008) pls help me .......:)

Login or Register to Ask a Question