Solved

calling perl to do search/replace from a bash script

Posted on 2008-10-28
9
507 Views
Last Modified: 2013-12-26
i wrote a small bash script to do a mass search/replace using 2 files...

$DESC is the file with the labels to put in the destination file
$XML is the destination file (the file with the entries that need to be replaced therein)

i have it echoing the regex line to stdout for diagnostic purposes and it looks like this on the first item:
toreplaceinfal: 's/<description>ifAdminStatus\.1<\/description>/<description>ETech<\/description>/g'


if i take the 's/<description> and prepend a perl -p -i -e on the ordinary shell, it works fine, but it doesnt work from within the script...

DESC=change
XML=go
NR=0
TOREPLACE="ifAdminStatus"
 
# Grab all the descriptions, count them, then correspond fo the second file #
        for i in `seq 1 1`;
        do
                NR=`expr $NR + 1`
                NRP="$NR"p
                sed -n "$NR"p $XML | grep "<description>" > /dev/null
                COUNTER=`expr $COUNTER + 1`
                NEWDESC=`sed -n "$COUNTER"p "$DESC"`
                TOREPLACE1="$TOREPLACE"$COUNTER
                TOREPLACEFNL="'s/<description>"$TOREPLACE"\."$COUNTER"<\/description>/<description>"$NEWDESC"<\/description>/g'"
                echo "toreplace1: $TOREPLACE1"
                echo "newdesc: $NEWDESC"
                echo "XML: $XML"
                echo "toreplaceinfal: $TOREPLACEFNL"
#               read BUF1
                perl -p -i -e $TOREPLACEFNL $XML

Open in new window

0
Comment
Question by:Jm2005
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
9 Comments
 
LVL 84

Expert Comment

by:ozo
ID: 22826080
TOREPLACEFNL="s/<description>"$TOREPLACE"\."$COUNTER"<\/description>/<description>"$NEWDESC"<\/description>/g"
0
 
LVL 48

Expert Comment

by:Tintin
ID: 22826135
BTW, what's the logic of

for i in `seq 1 1`

when that's a long hand way of writing

for i in 1

0
 

Author Comment

by:Jm2005
ID: 22826142
okay, that worked!

one last piece of this....

some of the lines are either blank, or have text which may screw the regex up (in $newdesc) how to fix?
0
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

 

Author Comment

by:Jm2005
ID: 22826171
tintin: the logic of that the loop needs to run multiple times, (428 in this instance) once i get the proc debugged, i'll adjust the loop accordingly.
0
 

Author Comment

by:Jm2005
ID: 22826184
on those lines which cause issues with the replace... i get the following error:

Substitution replacement not terminated at -e line 1.
0
 

Author Comment

by:Jm2005
ID: 22826202
below is the syntax of the regex, and the error.
newdesc: Lake Placid Point to Point
XML: go
toreplaceinfal: s/<description>ifAdminStatus\.161<\/description>/<description>Connection to Lake Placid Point to Point<\/description>/g
Substitution replacement not terminated at -e line 1.

Open in new window

0
 
LVL 84

Assisted Solution

by:ozo
ozo earned 500 total points
ID: 22826357
If I'm understanding what you're doing,  this is probably easier to write as
DESC=change
XML=go
NR=0
TOREPLACE="ifAdminStatus"
perl -i.bak -pe 'BEGIN{chomp(@n=<STDIN>)}s/(<description>)'$TOREPLACE'\.(\d+)(<\/description>)/$1$n[$2-1]$3/g' <$DESC $XML
0
 
LVL 84

Assisted Solution

by:ozo
ozo earned 500 total points
ID: 22826377
TOREPLACEFNL="s/<description>"$TOREPLACE"\."$COUNTER"<\/description>/<description>$NEWDESC<\/description>/g"
0
 
LVL 84

Accepted Solution

by:
ozo earned 500 total points
ID: 22826438
perl -p -i -e "$TOREPLACEFNL" $XML
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Email validation in proper way is  very important validation required in any web pages. This code is self explainable except that Regular Expression which I used for pattern matching. I originally published as a thread on my website : http://www…
A quick Powershell script I wrote to find old program installations and check versions of a specific file across the network.
Learn the basics of modules and packages in Python. Every Python file is a module, ending in the suffix: .py: Modules are a collection of functions and variables.: Packages are a collection of modules.: Module functions and variables are accessed us…
The viewer will learn how to dynamically set the form action using jQuery.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question