Urgent help pls.how to extract two lines having same starting number

 
Thread Tools Search this Thread
Homework and Emergencies Emergency UNIX and Linux Support Urgent help pls.how to extract two lines having same starting number
# 1  
Old 03-16-2010
Urgent help pls.how to extract two lines having same starting number

Hi ,

I have a huge file like this

=245 this is testing
=035 abc123
=245 this is testing1
=035 abc124
=245 this is testing2
=035 abc125
=035 abc126
=245 this is testing3

here i have to pull out those lines having two =035 instead of alternative 035 and 245 i.e extract abc125 and abc126. any command or script for this . please help

Regards
uma
# 2  
Old 03-16-2010
So if two lines begin the same then pull out those values? Or if two lines are exactly =035, then extract the rest of the line? Or if any number of consecutive lines are =035 then print out them all? Give this a go:
Code:
awk 'last==$1 { if (value) print value; print $2; value=""; next; } { last=$1;value=$2 }' filename.txt

# 3  
Old 03-17-2010
Try:
Code:
awk '/035/ { f++; s=s" "$2; } !/035/ {f=0;s="";} f==2 { print s; }' file

# 4  
Old 03-17-2010
Hi Otheus & Dennis

Thanks a lot !!!.It works accordingly.Once again Thanks for the timely help.

Regards
Uma
# 5  
Old 03-17-2010
I almost feel good about this. I still have no idea what umapearl really wanted Smilie
# 6  
Old 03-17-2010
Quote:
Originally Posted by otheus
I almost feel good about this. I still have no idea what umapearl really wanted Smilie

Smilie Thats funny...Smilie

umapearl looks for consecutive lines containing 035 and take the 2nd column of it.. [Or am I got it wrong???Smilie]
# 7  
Old 03-17-2010
Hi Otheus & Denny,

Ya Denny is wrightSmilie

I think little amendment is required, dono if possible

=245 this is testing
=035 abc123
=245 this is testing1
=035 abc124
=245 this is testing2
=035 abc125
=035 abc126
=245 this is testing3
=035 abc127
=035 abc128

=035 abc129
=245 this is testing 4

Here it is extracting abc125,abc126 ,abc127,abc128,abc129 but it should not extract abc126 and abc129 because it is followed by =245 line.

Appreciate your time

Regards
uma
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to grep a line not starting with # from a file (there are two lines starting with # and normal)?

e.g. File name: File.txt cat File.txt Result: #INBOUND_QUEUE=FAQ1 INBOUND_QUEUE=FAQ2 I want to get the value for one which is not commented out. Thanks, (3 Replies)
Discussion started by: Tanu
3 Replies

2. Shell Programming and Scripting

Extract between lines starting with and

I have a combination of patterns to search. file.txt contains below: H2016-02-10 A74867712 I1556539758 Xjdflk534jfl W0000055722327732 W0000056029009389 A74867865 I1556536434 W0000055822970840 W0000055722325916 A74868015 I1556541270 C0000055928920421 E lines starting with A are... (5 Replies)
Discussion started by: chakrapani
5 Replies

3. UNIX for Dummies Questions & Answers

Extract lines starting with rs

hello! could u, please, help: i have a file that includes 6 columns space delimited 1 rs4477212 0 82154 0 T 1 rs6680825 0 91472 0 G 1 rs9326626 0 570178 0 T 1 rs12123356 0 724702 0 C I need to extract to a separate file lines... (5 Replies)
Discussion started by: kush
5 Replies

4. Shell Programming and Scripting

extract the lines by index number

Hi All, I want to extract the lines from file1 by using the index numbers from file2. In example, cat file1.txt 265 ABC 956 ... 698 DFA 456 ... 456 DDD 145 ... 125 DSG 154 ... 459 CGB 156 ... 490 ASF 456 ... 484 XFH 489 ... 679 hgt 481 ... 111 dfg 986 ... 356 vhn 444 ...... (7 Replies)
Discussion started by: senayasma
7 Replies

5. UNIX for Dummies Questions & Answers

Extract n number of lines from a file successively

Hello, I have a file with over 100,000 lines. I would like to be able extract 5000 lines at a time and give it as an input to another program. sed -n '1,5000p' <myfile> > myOut Similarly for 5001-10000 10001-15000 .... How can I do this in a loop? Thanks, Guss (5 Replies)
Discussion started by: Gussifinknottle
5 Replies

6. Shell Programming and Scripting

Awk to extract lines with a defined number of characters

This is my problem, my file (file A) contains the following information: Now, I would like to create a file (file B) containing only the lines with 10 or more characters but less than 20 with their corresponding ID: Then, I need to compare the entries and determine their frequency. Thus, I... (7 Replies)
Discussion started by: Xterra
7 Replies

7. Shell Programming and Scripting

awk if statement matching all lines starting w/ a number

Does awk have a syntax for a range of numbers or is this the best way? if ($1 >= 0 && $1 <= 9 ) (7 Replies)
Discussion started by: Arsenalman
7 Replies

8. 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

9. Shell Programming and Scripting

How to print the number of lines from a file, the starting string should be passed`

Hi , I have file, which has the below content: line 100 a b c d line300 a s d f s line200 a s d a (3 Replies)
Discussion started by: little_wonder
3 Replies

10. UNIX for Dummies Questions & Answers

extract some specific text file urgent pls

i have a big text file . i want to create new file as extract some specific text from the big file i am using hp ux please help (2 Replies)
Discussion started by: reyazan
2 Replies
Login or Register to Ask a Question