Extracting line1 from a file with certain file pattern in line 7


 
Thread Tools Search this Thread
# 1  
Extracting line1 from a file with certain file pattern in line 7

Hello there, I am new to unix and would like to do the following, hoping someone would give some guide, thanks in advance.

Lets say i have a file like this:

Code:
A w x y w x 0.1
B w x y w x 0.3
C w x y w x 0.7
D w x y w x 0.9
E w x y w x 0.2

So i would like to extract line 1 data where line 7 have a value of more than 0.3

So i should get something like this as a result file

Code:
B
C
D

and yes, i would like to include the value 0.3 also, so, B is included

Thanks in advance

Last edited by Don Cragun; 09-15-2015 at 05:33 AM.. Reason: Add CODE tags.
# 2  
Code:
awk '$7>=0.3{print $1}' inputfile

This User Gave Thanks to balajesuri For This Post:
# 3  
Quote:
Originally Posted by balajesuri
Code:
awk '$7>=0.3{print $1}' inputfile

It works like miracle, thanks a lot!!!!!
 

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Insert content of file before the first occurrence of a line starts with a pattern in another file

Hi all, I'm new to scripting.. facing some problems while inserting content of a file into another file... I want to insert content of a file (file2) into file1, before first occurrence of "line starts with pattern" in file1 file1 ====== working on linux its unix world working on... (14 Replies)
Discussion started by: Jagadeesh Kumar
14 Replies

2. Shell Programming and Scripting

Read line1 from file1 - make it line1 of file2

Hi friends I have two files cat file1 i am the header a b c d cat file2 e f g h I want a script that would give me file2 with the header/first line as if in file1 (3 Replies)
Discussion started by: jacobs.smith
3 Replies

3. Shell Programming and Scripting

Reading line1 with line2 and line 2 with line 3 in unix

Hi, I have a requirement where i have to read a file line by line and see if the string(fixed postion 10 to 15 in the file) in line 2 is greater than string in line 1. I have used following code while read LINE1 do current_inv_no=$(echo "$LINE1" | cut -c 10-15) read... (2 Replies)
Discussion started by: chethanbg2010
2 Replies

4. Shell Programming and Scripting

extracting line numbers from a file and redirecting them to another file

i have applied the following command on a file named unix.txt that contains the string "linux from the text" grep -n -i -w "linux from the text" unix.txt and the result is 5:Today's Linux from the text systems are split into various branches, developed over time by AT&T as well as various... (5 Replies)
Discussion started by: arindamlive
5 Replies

5. UNIX for Dummies Questions & Answers

extracting pattern from every line

My scenario: 1. textfle 2. every line similar to: "...____ your sister?is1are0am0Grammar point1_______ the chairs in..." 3. need to extract only the numbers in each line, eg 001 in the case above. Tried different GREP/Sed combinations but...here I am An output like that would be... (9 Replies)
Discussion started by: eldeingles
9 Replies

6. Shell Programming and Scripting

extracting columns using pattern file from source file

Hi experts,Please help me for the below requirement. i have a source file.(lets say contains 50 columns). I am extarcting five columns from the source file by using pattern file. for example input file:--------a,b,c,d,"a,g","v b",s,koutputfile=======a,"a,g","v b",s,kThanks in advance subhendu (2 Replies)
Discussion started by: subhendu81
2 Replies

7. Shell Programming and Scripting

Searching a pattern in file and deleting th ewhole line containing the pattern

Hi All, Please can someone assist in the script I have made that searches a pattern in a file and delete the whole line containing the pattern. #!bin/sh # The pattern that user want to add to the files echo "Enter the pattern of the redirect" read value # check if the user has... (1 Reply)
Discussion started by: Shazin
1 Replies

8. Shell Programming and Scripting

Extracting line from a file

Hi, I would like to extract a certain portion of sentences from a particular sentence i.e. to extract the last section embrace by input output Please advice. Cheers (6 Replies)
Discussion started by: dwgi32
6 Replies

9. Shell Programming and Scripting

Extracting a line in a text file

If my file looks like this…. 10 20 30 and I want to take each line individually and put it in a variable so it can be read later in it's on individual test statement, how can I do that? I guess what I'm asking is how can I extract each line individually. Thanks (5 Replies)
Discussion started by: terryporter51
5 Replies

10. UNIX for Dummies Questions & Answers

Get line1 and line4 in a repeat pattern file

I have a datafile contain hundreds of lines: line1 1 2 line4 ================== line1 4 2 line4 ================== line1 3 1 line4 =================== (3 Replies)
Discussion started by: bobo
3 Replies

Featured Tech Videos