awk to print first row with forth column and last row with fifth column in each file


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers awk to print first row with forth column and last row with fifth column in each file
# 1  
Old 02-09-2013
awk to print first row with forth column and last row with fifth column in each file

file with this content
Quote:
PPP11 OFS HIGH 1200 1401 + 0 KNOW
PPP22 OFS HIGH 1433 1588 - 2 KNOW
Quote:
u want to print first row with fourth column and second row with fifth column; the code is below
Code:
awk 'NR==1 {print $4} && NR==2 {print $5}' file

The error is shown with syntax error; what can be done

Quote:
And another question is that if there is to print first row with fourth column and last row with fifth column; in each file; how the solution with awk will be?
# 2  
Old 02-09-2013
Quote:
Originally Posted by cdfd123
file with this content

Code:
PPP11 OFS HIGH 1200 1401 + 0 KNOW
PPP22 OFS HIGH 1433 1588 - 2 KNOW

u want to print first row with fourth column and second row with fifth column; the code is below
Code:
awk 'NR==1 {print $4} && NR==2 {print $5}' file

The error is shown with syntax error; what can be done

And another question is that if there is to print first row with fourth column and last row with fifth column; in each file; how the solution with awk will be?
First, please use CODE tags (not QUOTE tags) to show contents of files.

Second, we seem to have a language barrier. I do not understand what you want. Are you asking for a script that uses awk to read two lines from a file and write just column 4 from the 1st row and column 5 from the 2nd row? If this is what you want, you can get it using something like:
Code:
awk 'NR==1 {print $4}
NR==2 {print $5}' file

Are you asking for a script that reads a file and prints the 1st line that contains 4 or more columns and the 2nd line that contains 5 or more columns?

Please show us the output you want from the sample input you provide (in CODE tags) so we more clearly understand what you're trying to do.
This User Gave Thanks to Don Cragun For This Post:
# 3  
Old 02-09-2013
About how to print: "last row with fifth column; in each file":
Code:
END{ print $5 }

or in case you are using gawk 4.x:
Code:
ENDFILE{ print $5 }

These 2 Users Gave Thanks to user8 For This Post:
# 4  
Old 02-09-2013
@user8: not every awk retains the fields in the END section. To get around this:
Code:
{s=$5} END{ print s }

This User Gave Thanks to Scrutinizer For This Post:
# 5  
Old 02-09-2013
Quote:
Originally Posted by Scrutinizer
@user8: not every awk retains the fields in the END section.
You are right. I should have mentioned this.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Print every alternate column in row in a text file

Hi, I have a comma separated file. I would like to print every alternate columns into a new row. Example input file: Name : John, Age : 30, DOB : 30-Oct-2018 Example output: Name,Age,DOB John,30,30-Oct-2018 (3 Replies)
Discussion started by: Lini
3 Replies

2. Shell Programming and Scripting

Print first row of column a, last row of column b if column a has the same value

I have a table with this structure: cola colb colc 1 19 lemon 20 31 lemon 32 100 lemon 159 205 cherries 210 500 cherries and need to parse it into this format: cola colb colc 1 100 lemon 159 500 cherries So I need the first row of cola and the last row of colb if colc has the... (3 Replies)
Discussion started by: coppuca
3 Replies

3. Shell Programming and Scripting

Print row on 4th column to all row

Dear All, I have input : SEG901 5173 9005 5740 SEG902 5227 5284 SEG903 5284 5346 SEG904 5346 9010 SEG905 5400 5456 SEG906 5456 5511 SEG907 5511 9011 SEG908 5572 9015 SEG909 5622 9020 SEG910 5678 5739 SEG911 5739 5796 SEG912 5796 9025 ... (3 Replies)
Discussion started by: attila
3 Replies

4. Shell Programming and Scripting

Print every 5 4th column values as separate row with different first column

Hi, I have the following file, chr1 100 200 20 chr1 201 300 22 chr1 220 345 23 chr1 230 456 33.5 chr1 243 567 90 chr1 345 600 20 chr1 430 619 21.78 chr1 870 910 112.3 chr1 914 920 12 chr1 930 999 13 My output would be peak1 20 22 23 33.5 90 peak2 20 21.78 112.3 12 13 Here the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies

5. Shell Programming and Scripting

Print unique names in each row of a specific column using awk

Is it possible to remove redundant names in the 4th column? input cqWE 100 200 singapore;singapore AZO 300 400 brazil;america;germany;ireland;germany .... .... output cqWE 100 200 singapore AZO 300 400 brazil;america;germany;ireland (4 Replies)
Discussion started by: quincyjones
4 Replies

6. Shell Programming and Scripting

Print the row element till the next row element appear in a column

Hi all I have file with columns F3 pathway CPS F2 H2 H4 H5 H6 no pathway CMP H7 H8 H9 H10 My expected output is F3 pathway CPS F2 pathway CPS (10 Replies)
Discussion started by: Priyanka Chopra
10 Replies

7. Shell Programming and Scripting

Subtracting each row from the first row in a single column file using awk

Hi Friends, I have a single column data like below. 1 2 3 4 5 I need the output like below. 0 1 2 3 4 where each row (including first row) subtracting from first row and the result should print below like the way shown in output file. Thanks Sid (11 Replies)
Discussion started by: ks_reddy
11 Replies

8. Shell Programming and Scripting

AWK Script - Print a column - within a Row Range

Hi, Please read the whole thread. I have been working on this script below. It works fine, feel free to copy and test with the INPUT File below as well. example: PACKET DATA PROTOCOL CONTEXT DATA APNID PDPADD EQOSID VPAA PDPCH PDPTY PDPID 10 ... (6 Replies)
Discussion started by: panapty
6 Replies

9. Shell Programming and Scripting

Moving data from a specified column/row to another column/row

Hello, I have an input file like the following: 11_3_4 2_1_35 3_15__ _16989 Where '_' is a space. The data is in a table. Is there a way for the program to prompt the user for x1,y1 and x2,y2, where x1,y1 is the desired number (for example x=6 y=4 is a value of 4) and move to a desired spot... (2 Replies)
Discussion started by: jl487
2 Replies

10. Shell Programming and Scripting

Changing the column for a row in a text file and adding another row

Hi, I want to write a shell script which increments a particular column in a row from a text file and then adds another row below the current row with the incremented value . For Eg . if the input file has a row : abc xyz lmn 89 lm nk o p I would like the script to create something like... (9 Replies)
Discussion started by: aYankeeFan
9 Replies
Login or Register to Ask a Question