grep out and fix a section Post: 302533095

Sponsored Content

Top Forums Shell Programming and Scripting grep out and fix a section Post 302533095 by richsark on Wednesday 22nd of June 2011 05:37:26 PM

06-22-2011

Registered User

grep out and fix a section

I have a file that contains a section of information like this:

Code:

10_82_150_13.netshhcp Server 10.82.150.13 Scope 10.82.128.0 Add reservedip 10.82.130.54 0060b09f4b74 "PR_EMD_METALS1.san.local" "TSF 5th floor room 507 h
plj4000" "BOTH"
10_82_150_13.netshhcp Server 10.82.150.13 Scope 10.82.128.0 Add reservedip 10.82.133.146 0709080302 "LAG CONTROL SYS" "LAG CONTROL SYS" "BOTH"

Basically the issue is the 0060b09f4b74 part needs to be 12 digits long. which this example is fine.

or the next entry 0709080302 its not.

What I would like is a way to fix these short MAC's and replace with 12 zeros 000000000000 and pipe the new file out

is there a quick command line I can do? perl/sed/awk??

I tried these with no success:

Code:

grep s/Add reservedip \([0-9]\{1,3\}\.[0-9]\{1,3\}\.[0-9]\{1,3\}\.[0-9]\{1,3\}\) [a-f0-9]{4,11}/Add reservedip \1 000000000000/ 10_82_150_13.netsh

grep: reservedip: No such file or directory
grep: ([0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}): No such file or directory
grep: [a-f0-9]4/Add: No such file or directory
grep: [a-f0-9]11/Add: No such file or directory
grep: reservedip: No such file or directory
grep: 1: No such file or directory
grep: 000000000000/: No such file or directory

---------------------------------------------------------------------------

Code:

Perl -pe 's{\s[a-f0-9]{4,11}\s}{ 000000000000 }' 10_82_150_13.netsh

However, I see a few lines that have more digits for MAC

Code:

Dhcp Server 10.82.150.13 Scope 10.82.128.0 Add reservedip 10.82.135.1 0111111222223333 "switch setup" "check whoip for info" "BOTH"

and too short ones like: (( aa ))

Code:

Dhcp Server 10.82.150.13 Scope 10.82.128.0 Add reservedip 10.82.135.133 aa "security" "camera" "BOTH"

Thanks for your help in advance

Last edited by Franklin52; 06-23-2011 at 03:44 AM.. Reason: Please use code tags

richsark

View Public Profile for richsark

Find all posts by richsark

9 More Discussions You Might Find Interesting

1. Post Here to Contact Site Administrators and Moderators

New section

What are the chances of possibly posting some of the more common how-to type stuff for the newbies so we can avoid the repititious stuff that appears every other day? Not so much like a Q&A forum, but more like a reference area for the mundane stuff. Beyond searching the forum, I think people...

2. Post Here to Contact Site Administrators and Moderators

New Section

Just like we have a section "Unix for dummies..." , why not have a section on UNIX BACKUP AND RECOVERY Thanks :)

3. UNIX for Dummies Questions & Answers

how can i extract text section via grep

hi, i have a very long text file. i need to extract with grep command a certain part. for example text file include 1ooo rows: 1.... 2... 3... . . . 1000 i want to view with grep only rows 50-100. any ideas will be appreciated thanks...

4. Shell Programming and Scripting

Extract section of file based on word in section

I have a list of Servers in no particular order as follows: virtualMachines="IIBSBS IIBVICDMS01 IIBVICMA01"And I am generating some output from a pre-existing script that gives me the following (this is a sample output selection). 9/17/2010 8:00:05 PM: Normal backup using VDRBACKUPS...

5. Shell Programming and Scripting

Prepend first line of section to each line until the next section header

I have searched in a variety of ways in a variety of places but have come up empty. I would like to prepend a portion of a section header to each following line until the next section header. I have been using sed for most things up until now but I'd go for a solution in just about anything--...

6. Shell Programming and Scripting

Grep or print each section of a file on one line with a separator

I can obtain information from itdt inventory command however it display as below, I'd like to print each entity on one line but seperated by : the file is something like and each section ends with Volume Tag Drive Address 256 Drive State ................... Normal ASC/ASCQ...

7. Shell Programming and Scripting

Grep text and see all section

Hello I am looking for a way to look in files and to grep text and see the all section of the text ! Sharon123 deed 10000 class 360 ! sharon456 2000 deed ! Sharon789 live 3000 ! To grep "deed "an see the all section

8. Shell Programming and Scripting

How to Grep of by section?

I have a script that outputs this as a file John Smith ---------------- memberOf: example1;sampletest;test memberOf: example2;sampletest;test memberOf: example3;sampletest;test memberOf: example4;sampletest;test A Member of 4 Groups Sally Smith ---------------- memberOf:...

9. UNIX for Beginners Questions & Answers

Grep a section from an UNIX file obtaining only part of the data

Hello, I have a log file that has several sections "BEGIN JOB, End of job" like in the following example: 19/06/12 - 16:00:57 (27787398-449294): BEGIN JOB j1(27787398-449294) JOB1 19/06/12 - 16:00:57 (27787398-449294): DIGIT: 0 number of present logs : 1 19/06/12 - 16:00:57...

LEARN ABOUT POSIX

zgrep

ZGREP(1)						      General Commands Manual							  ZGREP(1)

NAME

       zgrep - search possibly compressed files for a regular expression

SYNOPSIS

       zgrep [ grep_options ] [ -e ] pattern filename...

DESCRIPTION

       Zgrep  invokes  grep  on  compressed  or  gzipped  files.   These  grep	options  will  cause  zgrep  to  terminate  with  an  error  code:
       (-[drRzZ]|--di*|--exc*|--inc*|--rec*|--nu*).  All other options specified are passed directly to grep.  If no file is specified,  then  the
       standard input is decompressed if necessary and fed to grep.  Otherwise the given files are uncompressed if necessary and fed to grep.

       If the GREP environment variable is set, zgrep uses it as the grep program to be invoked.

EXIT CODE

       2 - An option that is not supported was specified.

AUTHOR

       Charles Levert (charles@comm.polymtl.ca)

SEE ALSO

       grep(1), gzexe(1), gzip(1), zdiff(1), zforce(1), zmore(1), znew(1)

																	  ZGREP(1)

9 More Discussions You Might Find Interesting

1. Post Here to Contact Site Administrators and Moderators

New section

Discussion started by: ober5861

2. Post Here to Contact Site Administrators and Moderators

New Section

Discussion started by: kapilv

3. UNIX for Dummies Questions & Answers

how can i extract text section via grep

Discussion started by: meny

4. Shell Programming and Scripting

Extract section of file based on word in section

Discussion started by: jelloir

5. Shell Programming and Scripting

Prepend first line of section to each line until the next section header

Discussion started by: pagrus

6. Shell Programming and Scripting

Grep or print each section of a file on one line with a separator

Discussion started by: gefa

7. Shell Programming and Scripting

Grep text and see all section

Discussion started by: sharong

8. Shell Programming and Scripting

How to Grep of by section?

Discussion started by: ajetangay

9. UNIX for Beginners Questions & Answers

Grep a section from an UNIX file obtaining only part of the data

Discussion started by: mvalonso

LEARN ABOUT POSIX

zgrep