Visit Our UNIX and Linux User Community


Need to remove lines that start with an IP address


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need to remove lines that start with an IP address
# 1  
Old 07-30-2009
Need to remove lines that start with an IP address

Hi,

I keep having to remove lines have an IP address as the second field from my awstats logs, as it makes the processing fail.

Rather than do it individually each time (once or twice a week) it fails, I'd like to remove any lines from the file that have 3 digits and then a dot as the start of the second field as they are sure to be an IP.

The field separators are spaces

I know if the line starts with an IP I can easily do it with grep like so:

Code:
 grep -v '\^[0-9][0-9][0-9]' file > tempfile; mv tempfile file

But this is the second field so I imagine I have to use awk, right?

Any ideas would be appreciated

Last edited by sfisk; 07-30-2009 at 12:58 PM..
# 2  
Old 07-30-2009
yes you can use awk..
Code:
awk '$2 !~ /[0-9][0-9][0-9]./{print}' filename


Last edited by vidyadhar85; 07-30-2009 at 02:49 PM..

Previous Thread | Next Thread
Test Your Knowledge in Computers #125
Difficulty: Easy
UNIX is a certification of a complete OS system, not only a UNIX kernel.
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to print lines from a files with specific start and end patterns and pick only the last lines?

Hi, I need to print lines which are matching with start pattern "SELECT" and END PATTERN ";" and only select the last "select" statement including the ";" . I have attached sample input file and the desired input should be as: INPUT FORMAT: SELECT ABCD, DEFGH, DFGHJ, JKLMN, AXCVB,... (5 Replies)
Discussion started by: nani2019
5 Replies

2. Shell Programming and Scripting

awk to remove lines that do not start with digit and combine line or lines

I have been searching and trying to come up with an awk that will perform the following on a converted text file (original is a pdf). 1. Since the first two lines are (begin with) text they are removed 2. if $1 is a number then all text is merged (combined) into one line until the next... (3 Replies)
Discussion started by: cmccabe
3 Replies

3. UNIX for Dummies Questions & Answers

How can I replace the lines that start with a star and replace it with numbers start from 1?

I need to replace the (*) in the fist of a list with numbers using sed for example > this file contain a list * linux * computers * labs * questions to >>>> this file contain a list 1. linux 2. computers 3. labs 4. questions (7 Replies)
Discussion started by: aalbazie
7 Replies

4. Shell Programming and Scripting

Remove all lines which start with #

Oracle Linux 6.4/Bash I have a file like below. I want to remove all lines which start with # character. Can I do this vi editor ? If not , which other utility can I use for this ? # This is a test script CUSER=`id |cut -d"(" -f2 | cut -d ")" -f1` # Some text CDATE=`date +%y%m%d` ## get... (3 Replies)
Discussion started by: kraljic
3 Replies

5. Shell Programming and Scripting

Remove certain lines from file based on start of line except beginning and ending

Hi, I have multiple large files which consist of the below format: I am trying to write an awk or sed script to remove all occurrences of the 00 record except the first and remove all of the 80 records except the last one. Any help would be greatly appreciated. (10 Replies)
Discussion started by: nwalsh88
10 Replies

6. Shell Programming and Scripting

Remove lines between the start string and end string including start and end string Python

Hi, I am trying to remove lines once a string is found till another string is found including the start string and end string. I want to basically grab all the lines starting with color (closing bracket). PS: The line after the closing bracket for color could be anything (currently 'more').... (1 Reply)
Discussion started by: Dabheeruz
1 Replies

7. Shell Programming and Scripting

Remove spaces from start of file names

Hi, I have a directory with the following file names 01 - abc hyn 02-def 03-ghi.dir 04 - jhu.dir abc1 kil def bil The last two file names abc1 starts with one space and def starts with double space. I want these files in my directory to be renamed as ABC HYN DEF GHI.dir... (6 Replies)
Discussion started by: jacobs.smith
6 Replies

8. Shell Programming and Scripting

remove spaces and lines that start with --

Is it possible to remove empty lines between >humid-sets (bold) and also humidset that start with -- (for ex: > humid3 | () : | (+) ) Thanx in advance Note: The humid sets will be in thousands and lines will be more than 100 thousand. input > humid1 | () : | (+)... (7 Replies)
Discussion started by: quincyjones
7 Replies

9. Shell Programming and Scripting

remove colons in MAC address

whats the simplest method to remove the colons from a mac address in PERL? thanks & regards (3 Replies)
Discussion started by: hazno
3 Replies

10. UNIX for Dummies Questions & Answers

how to remove a logical ip address?

hi, i "accidentedly" added some logical ip address to my solaris 8 machine. now i want to remove them. i already man ifconfig but some how i just keep getting the wrong syntax. this is the command i used to add ifconfig hme0 addif 192.168.100.10 netmask 255.255.2550.0 up so, now... (2 Replies)
Discussion started by: champion
2 Replies

Featured Tech Videos