The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Dummies Questions & Answers
Google UNIX.COM
Home Forums Register Rules & FAQ Members List Arcade Search Today's Posts Mark Forums Read


UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !!


Other UNIX.COM Threads You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
deleting lines from multiple text files vrms Shell Programming and Scripting 3 04-25-2008 08:01 AM
Deleting lines in a file reachsamir Shell Programming and Scripting 2 05-29-2007 08:17 AM
Deleting last 2 lines from the file. videsh77 Shell Programming and Scripting 4 04-06-2007 10:14 AM
deleting lines in a log file BG_JrAdmin Shell Programming and Scripting 2 08-22-2006 08:12 AM
Deleting lines from a file Nirgude07 UNIX for Advanced & Expert Users 10 09-21-2005 01:58 PM

Reply
 
Submit Tools LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-16-2008
Registered User
 

Join Date: Feb 2008
Posts: 15
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiReddit! Stumble this Post!Spurl this Post!
Deleting lines in text file

Hi everyone,

I have text files that I want to delete lines from. I have searched through this forum for quite some time and found examples of both awk and sed. Unfortunately, I was not able to successfully do what I want. Well to some extent. I did manage to delete the first 15 lines from each of the text files, since all the text files will have the same first 15 lines.

So, I have a text file that looks like this:

Id First Name Last Name
--- ---------- ---------
1 Mary Jane
2 Joe Blowe

2 record(s) selected.

Return Status = 0


Notice the lines in bold....every text file will have this at the end. This file will be emailed and the recepients won't have a clue to what those two lines mean, so I would like to remove them. Any suggestions? THANKS!
Reply With Quote
Forum Sponsor
  #2 (permalink)  
Old 05-16-2008
Moderator
 

Join Date: Feb 2007
Posts: 1,279
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiReddit! Stumble this Post!Spurl this Post!
This should do the job:

Code:
awk '/record(s) selected.$/{exit}1' file
Regards
Reply With Quote
  #3 (permalink)  
Old 05-16-2008
Registered User
 

Join Date: Feb 2008
Posts: 15
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiReddit! Stumble this Post!Spurl this Post!
Hmm..that did not seem to have any results...but thanks anyways. What I did is:

awk 'FNR>15' myfile |grep -v -e "record(s) selected." -e "Return Status" > mynewfile



Don't know if that is the wrong way of doing it. I am sure you experienced folks will have a better way of doing it, but alas, it accomplished what I wanted.

Thanks again!!
Reply With Quote
  #4 (permalink)  
Old 05-16-2008
Moderator
 

Join Date: Feb 2007
Posts: 1,279
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiReddit! Stumble this Post!Spurl this Post!
Oops, forgot some quotes:

Code:
awk '/record\(s\) selected.$/{exit}1' file
Regards
Reply With Quote
  #5 (permalink)  
Old 05-16-2008
Registered User
 

Join Date: Feb 2008
Posts: 15
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiReddit! Stumble this Post!Spurl this Post!
Awesome, it worked! Don't you just love it how a single slash can make a difference?
Reply With Quote
Google UNIX.COM
Reply



Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -7. The time now is 05:31 PM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008 The CEP Blog All Rights Reserved -Ad Management by RedTyger

Search Engine Optimization by vBSEO 3.1.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102