Sponsored Content
Top Forums Shell Programming and Scripting Extract lines from text files Post 302885410 by edweena on Sunday 26th of January 2014 02:18:16 AM
Old 01-26-2014
Hi Cragun,

Thank you very much for your suggestions. I have rephrased my question below and changed the data. Please have a look at the question.

I have a folder f1 that contains some files. The content of the files are shown below.

Code:
REM  |---Residue---|    |--Structure--|   |-Phi-|   |-Psi-|  |-Area-|      1N8W
ASG  GLU A   98    1    C          Coil    360.00    145.18     236.2      1N8W
ASG  ILE A   99    2    C          Coil    -82.86    141.16      97.1      1N8W
ASG  ILE A  100    3    C          Coil   -115.85    140.04      33.4      1N8W
ASG  GLN A  101    4    E        Strand   -114.08    115.71      61.8      1N8W
ASG  GLY A  127   29    C          Coil    149.12    153.69      21.1      1N8W
ASG  GLU A  128   30    T          Turn    -81.07    168.08     150.8      1N8W
ASG  PHE A  129   31    T          Turn    -55.84    139.19      85.7      1N8W
ASG  CYS A  144   46    H    AlphaHelix    -67.95    -16.88       0.0      1N8W
ASG  GLN A  145   47    C          Coil    -86.59    -11.10      29.5      1N8W
ASG  LEU A  146   48    C          Coil    -68.82    158.46       0.0      1N8W
ASG  PRO A  147   49    C          Coil    -61.30    150.63      46.7      1N8W
ASG  ILE A  148   50    G      310Helix    -57.27    -35.92      84.1      1N8W
ASG  TYR A  301  166    E        Strand   -110.40    111.53      75.1      1N8W
ASG  LEU A  302  167    E        Strand    -98.11    143.77      19.7      1N8W

Desired output
Code:
ASG  ILE A   99    2    C          Coil    -82.86    141.16      97.1      1N8W
ASG  LEU A  146   48    C          Coil    -68.82    158.46       0.0      1N8W
ASG  LEU A  302  167    E        Strand    -98.11    143.77      19.7      1N8W

I want to extract the lines only if the values in the phi and psi columns between -67<=phi<=-99 and 100<=psi<=165
I would like to save the outputs in to another folder f2 with the input file names. I highly appreciate your valuable suggestions.

Thanks a lot.

Moderator's Comments:
Mod Comment I have restored post #1 to its original content and added the new data into this post, otherwise the thread would be difficult to follow

Moderator's Comments:
Mod Comment I have picked up some more of the updates to original posting so this message gives a complete picture of what is now being requested.

Last edited by Don Cragun; 01-26-2014 at 03:44 PM.. Reason: Pick up the requested selection criteria and delete the out of range output.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

extract the lines between specific line number from a text file

Hi I want to extract certain text between two line numbers like 23234234324 and 54446655567567 How do I do this with a simple sed or awk command? Thank you. ---------- Post updated at 06:16 PM ---------- Previous update was at 05:55 PM ---------- found it: sed -n '#1,#2p'... (1 Reply)
Discussion started by: return_user
1 Replies

2. Shell Programming and Scripting

Extract lines of text based on a specific keyword

I regularly extract lines of text from files based on the presence of a particular keyword; I place the extracted lines into another text file. This takes about 2 hours to complete using the "sort" command then Kate's find & highlight facility. I've been reading the forum & googling and can find... (4 Replies)
Discussion started by: DionDeVille
4 Replies

3. Shell Programming and Scripting

Extract lines from files

hi all, I have three files. The first file (FILE_INFO in my code) consists of four parameters for each line. 0.00765600 0.08450704 M3 E3 0.00441931 0.04878049 M4 E5 0.01904574 0.21022727 M5 E10 0.00510400 0.05633803 M6 E12 0.00905960 ... (11 Replies)
Discussion started by: my_Perl
11 Replies

4. Shell Programming and Scripting

extract particular lines from text file

I have two files file A which have a number in every row and file B which contains few hundred thousand rows with about 300 characters in each row (csv) What I need is to extract whole rows from B file (only these which numbers are indicated in A file) I also need to use cygwin. Any... (7 Replies)
Discussion started by: gunio
7 Replies

5. Shell Programming and Scripting

AWK: How to extract text lines between two strings

Hi. I have a text test1.txt file like:Receipt Line1 Line2 Line3 End Receipt Line4 Line5 Line6 Canceled Receipt Line7 Line8 Line9 End (9 Replies)
Discussion started by: TQ3
9 Replies

6. Shell Programming and Scripting

Extract two lines before and after the 'search text'

Hi Guys, I have a situation wherein I need to extract two lines from below the search string. Eg. Current: $ grep "$(date +'%a %b %e')" alert.log Mon Apr 12 03:58:10 2010 Mon Apr 12 12:51:48 2010 $ Here I would like the display to be something like Mon Apr 12... (6 Replies)
Discussion started by: geetap
6 Replies

7. UNIX for Dummies Questions & Answers

Help please, extract multiple lines from a text file

Hi all, I need to extract lines between the lines 'RD' and 'QA' from a text file (following). there are more that one of such pattern in the file and I need to extract all of them. however, the number of lines between them is varied in the file. Therefore, I can not just use 'grep -A' command.... (6 Replies)
Discussion started by: johnshembb
6 Replies

8. Shell Programming and Scripting

How to extract lines between tags into different files?

I have an xml file with the below data: unix>Cat address.xml <Address City=”Amsterdam” Street = “station straat” ZIPCODE="2516 CK " </Address> <Address City=”Amsterdam” Street = “Leeuwen straat” ZIPCODE="2517 AB " </Address> <Address City=”The Hauge” Street = “kirk straat” ... (1 Reply)
Discussion started by: LinuxLearner
1 Replies

9. Shell Programming and Scripting

extract lines from text after keyword

I have a text and I want to extract the 4 lines following a keyword! For example if I have this text and the keyword is AAA hello helloo AAA one two three four helloooo hellooo I want the output to be one two three four (7 Replies)
Discussion started by: stekanius
7 Replies

10. UNIX for Dummies Questions & Answers

Extract the same lines from the two files

I used to use this script to extract the same lines from two files: grep -f file1 file2 > outputfile now I have file1 AB029895 AF208401 AF309648 AF526378 AJ444445 AJ720950 AJ851546 AY568629 AY591907 AY994087 BU116401 BU116599 BU119689 BU121308 BU125622 BU231446 BU236750 BU237045 (4 Replies)
Discussion started by: yuejian
4 Replies
All times are GMT -4. The time now is 08:02 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy