Print row on 4th column to all row


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Print row on 4th column to all row
# 1  
Old 04-29-2014
Print row on 4th column to all row

Dear All,

I have input :

Code:
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    
SEG913 5845 5910    
SEG914 5910 9031    
SEG915 5965 9031    
SEG916 6027 6082    
SEG917 6082 9036    
SEG918 6129 6182    
SEG919 6182 6235    
SEG920 6235 9041    
SEG921 6290 6357    
SEG922 6357 9046    
SEG923 6406 6466    
SEG924 6466 6521    
SEG925 6521 9051    
SEG926 6572 6637    
SEG927 6637 9056    
SEG928 6697 6757    
SEG929 6757 6812

We need to print row on 4th column to all row.

Expected result:

Code:
SEG901 5173 9005 5740
SEG902 5227 5284 5740    
SEG903 5284 5346 5740   
SEG904 5346 9010 5740    
SEG905 5400 5456 5740    
SEG906 5456 5511 5740    
SEG907 5511 9011 5740    
SEG908 5572 9015 5740    
SEG909 5622 9020 5740    
SEG910 5678 5739 5740    
SEG911 5739 5796 5740    
SEG912 5796 9025 5740    
SEG913 5845 5910 5740    
SEG914 5910 9031 5740    
SEG915 5965 9031 5740    
SEG916 6027 6082 5740    
SEG917 6082 9036 5740    
SEG918 6129 6182 5740    
SEG919 6182 6235 5740    
SEG920 6235 9041 5740    
SEG921 6290 6357 5740    
SEG922 6357 9046 5740    
SEG923 6406 6466 5740    
SEG924 6466 6521 5740    
SEG925 6521 9051 5740    
SEG926 6572 6637 5740    
SEG927 6637 9056 5740    
SEG928 6697 6757 5740    
SEG929 6757 6812 5740 

Thanks for advance.
Attila
# 2  
Old 04-29-2014
Code:
awk 'NR == 1{p=$4; print $0; next} {$4 = ($4 == "") ? p : $4}1' file

This User Gave Thanks to SriniShoo For This Post:
# 3  
Old 04-29-2014
This is a little bit simpler than SriniShoo's script and seems to do what was requested (but it doesn't print the trailing spaces that were included in the expected results shown in the 1st message in this thread):
Code:
awk '
NR == 1 { r1f4 = $4 }
	{ $4 = r1f4 }
1' input

If you want to try this on a Solaris/SunOS system, change awk to /usr/xpg4/bin/awk or /usr/xpg6/bin/awk.
These 2 Users Gave Thanks to Don Cragun For This Post:
# 4  
Old 04-29-2014
SriniShoo, it work.

Thank you.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Print a row with the max number in a column

Hello, I have this table: chr1_16857_17742 - chr1 17369 17436 "ENST00000619216.1"; "MIR6859-1"; - 67 chr1_16857_17742 - chr1 14404 29570 "ENST00000488147.1"; "WASH7P"; - 885 chr1_16857_18061 - chr1 ... (5 Replies)
Discussion started by: coppuca
5 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

Get row number from file1 and print that row of file2

Hi. How can we print those rows of file2 which are mentioned in file1. first character of file1 is a row number.. for eg file1 1:abc 3:ghi 6:pqr file2 a abc b def c ghi d jkl e mno f pqr ... (6 Replies)
Discussion started by: Abhiraj Singh
6 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. UNIX for Dummies Questions & Answers

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

file with this content awk 'NR==1 {print $4} && NR==2 {print $5}' file The error is shown with syntax error; what can be done (4 Replies)
Discussion started by: cdfd123
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

How to print column based on row number

Hi, I want to print column value based on row number say multiple of 8. Input file: line 1 67 34 line 2 45 57 . . . . . . line 8 12 46 . . . . . . line 16 24 90 . . . . . . line 24 49 67 Output 46 90 67 (2 Replies)
Discussion started by: Surabhi_so_mh
2 Replies

9. Shell Programming and Scripting

Print row if value in column 1 is the first occurence

Hi All, I would like to have a script which is able to perform the below. Print the whole row if column1 which is "0001" for the below example is the first occurrence. Subsequent "0001" occurrence will not be printed out and so on. Can any expert help ? Input: 0001 k= 40 0001 k= 2... (7 Replies)
Discussion started by: Raynon
7 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