Cut from specific line number to a line number


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Cut from specific line number to a line number
# 1  
Old 04-19-2013
Linux Cut from specific line number to a line number

Hi All,

I've a file like this..

Sheet1
a,1
a,2
a,3
a,4
a,5
Sheet2
a,6
a,7
a,8
a,9
a,10
Sheet3
a,11
a,12
a,13
a,14
a,15

I want to cut data from line starting after Sheet2 to line before Sheet3. i.e my output will be like

a,6
a,7
a,8
a,9
a,10

Here, I don't know line number of string 'Sheet2' & 'Sheet3'. I've done googling & searched through this forum , but have not able to do it.

I'm sure you guys wont disappoint me..Smilie

Cheers

Last edited by manab86; 04-19-2013 at 03:20 AM..
# 2  
Old 04-19-2013
You do mean you want the following, right?
Code:
a,6
a,7
a,8
a,9
a,10

# 3  
Old 04-19-2013
Quote:
Originally Posted by hanson44
You do mean you want the following, right?
Code:
a,6
a,7
a,8
a,9
a,10

Yes, my output will be like above..
# 4  
Old 04-19-2013
Yes, we wouldn't want to disappoint. Smilie Here are two possible ways, both of which I like:
Code:
$ sed -n "/Sheet2/,/Sheet3/ p" file | grep -v Sheet
a,6
a,7
a,8
a,9
a,10

Code:
$ awk '/Sheet3/ { exit } p == 1 { print } /Sheet2/ { p = 1 }' file
a,6
a,7
a,8
a,9
a,10

These 2 Users Gave Thanks to hanson44 For This Post:
# 5  
Old 04-19-2013
It worked like charm..Thank you so very much for help.. This forum is awesome

Cheers Smilie
# 6  
Old 04-19-2013
You can use a simple grep line as well.
Code:
grep -v "Sheet[0-9]\{1,3\}" file

---------- Post updated at 12:57 AM ---------- Previous update was at 12:55 AM ----------

Sorry misread, i cannot edit post.

---------- Post updated at 12:57 AM ---------- Previous update was at 12:57 AM ----------

Sorry misread, i cannot edit post.
# 7  
Old 04-19-2013
Code:
$ sed -n '/Sheet2/,/Sheet3/ {/Sheet/d; p}' file
a,6
a,7
a,8
a,9
a,10

These 2 Users Gave Thanks to RudiC For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Delete a specific line containing non consecutive number?

Dear Specialists, I have following data 1 1 2 2 2 3 3 3 6 4 3 4 5 4 9 6 5 11 7 6 7 and I would like to obtain data like below 1 1 2 2 2 3 4 3 4 7 6 7 (2 Replies)
Discussion started by: Ryan Kim
2 Replies

2. Shell Programming and Scripting

sed command to replace a line at a specific line number with some other line

my requirement is, consider a file output cat output blah sdjfhjkd jsdfhjksdh sdfs 23423 sdfsdf sdf"sdfsdf"sdfsdf"""""dsf hellow there this doesnt look good et cetc etc etcetera i want to replace a line of line number 4 ("this doesnt look good") with some other line ... (3 Replies)
Discussion started by: vivek d r
3 Replies

3. Shell Programming and Scripting

Write $line number into textfile and read from line number

Hello everyone, I don't really know anything about scripting, but I have to manage to make this script, out of necessity. #!/bin/bash while read -r line; do #I'm reading from a big wordlist instructions using $line done Is there a way to automatically write the $line number the script... (4 Replies)
Discussion started by: bobylapointe
4 Replies

4. Shell Programming and Scripting

new line after specific number character

Hi All, I have input file like this: input1: ( 1083479)=T 158V 1798, T 391V 1896,T 1138V 2273,T 1547V 2477,T 2249V 2917,T 3278V 3234,T 4152V 3495,T 5500V 3631, ( 1083501)=T 181V 1851, T 459V 1954,T 810V 2141,T 1188V 2372,T 1638V 2696,T 2731V 3124,T 4799V 3640,... (5 Replies)
Discussion started by: attila
5 Replies

5. UNIX for Dummies Questions & Answers

How to read contents of a file from a given line number upto line number again specified by user

Hello Everyone. I am trying to display contains of a file from a specific line to a specific line(let say, from line number 3 to line number 5). For this I got the shell script as shown below: if ; then if ; then tail +$1 $3 | head -n $2 else ... (5 Replies)
Discussion started by: grc
5 Replies

6. Shell Programming and Scripting

How would i delete a line at specific line number

Hi guys , I m writing a script to delete a line at particular location. But i m unable to use variable for specifying line number. for example. sed -n '7!p' filename works fine and deletes 7th line from my file but sed -n '$variable!p' filename gives following error. sed: -e... (12 Replies)
Discussion started by: pinga123
12 Replies

7. Shell Programming and Scripting

using sed to replace a specific string on a specific line number using variables

using sed to replace a specific string on a specific line number using variables this is where i am at grep -v WARNING output | grep -v spawn | grep -v Passphrase | grep -v Authentication | grep -v '/sbin/tfadmin netguard -C'| grep -v 'NETWORK>' >> output.clean grep -n Destination... (2 Replies)
Discussion started by: todd.cutting
2 Replies

8. Shell Programming and Scripting

how to get the data from line number 1 to line number 100 of a file

Hi Everybody, I am trying to write a script that will get some perticuler data from a file and redirect to a file. My Question is, I have a Very huge file,In that file I have my required data is started from 25th line and it will ends in 100th line. I know the line numbers, I need to get all... (9 Replies)
Discussion started by: Anji
9 Replies

9. Shell Programming and Scripting

Adding a columnfrom a specifit line number to a specific line number

Hi, I have a huge file & I want to add a specific text in column. But I want to add this text from a specific line number to a specific line number & another text in to another range of line numbers. To be more specific: lets say my file has 1000 lines & 4 Columns. I want to add text "Hello"... (2 Replies)
Discussion started by: Ezy
2 Replies

10. Shell Programming and Scripting

Appending line number to each line and getting total number of lines

Hello, I need help in appending the line number of each line to the file and also to get the total number of lines. Can somebody please help me. I have a file say: abc def ccc ddd ffff The output should be: Instance1=abc Instance2=def Instance3=ccc Instance4=ddd Instance5=ffff ... (2 Replies)
Discussion started by: chiru_h
2 Replies
Login or Register to Ask a Question