Using SED with variable to replace strings in while loop Post: 302562436

Sponsored Content

Top Forums Shell Programming and Scripting Using SED with variable to replace strings in while loop Post 302562436 by cgkmal on Thursday 6th of October 2011 11:31:41 PM

10-07-2011

Registered User

Using SED with variable to replace strings in while loop

Hi guys,

Hi have this input (Menu.xml)

Code:

<?xml version="1.0" encoding="ISO-8859-1"?> 
<breakfast_menu> 
    <food> 
        <name>Berry-Berry Belgian Waffles</name> 
        <price>$8.95</price> 
        <calories>900</calories> 
    </food> 
    <food> 
        <name>French Toast</name> 
        <price>$4.50</price> 
        <calories>600</calories> 
    </food> 
</breakfast_menu>

and the required output is as below (basically replace text between <>, the text in red remains equal)

Code:

    <Catg> 
        <Unit><Data :Value="String">Berry-Berry Belgian Waffles</Data></Unit> 
        <Unit><Data :Value="String">$8.95</Data></Unit> 
        <Unit><Data :Value="String">900</Data></Unit> 
    </Catg> 
    <Catg> 
        <Unit><Data :Value="String">French Toast</Data></Unit> 
        <Unit><Data :Value="String">$4.50</Data></Unit> 
        <Unit><Data :Value="String">600</Data></Unit> 
    </Catg>

I'm trying with the code below to replace the values between "<>" to right, but is not working I'm not sure why.

Code:

Myfile=Menu.xml

awk -F "[<>]" '{print $2}' ${Myfile} | while read data
do
  cat <<-TEXT1
     if ["${data}" -eq "food"]; then
         sed "s/${data}/Catg/" ${Myfile}
     else
         sed "s/${data}/Unit><Data :Value="String"/" ${Myfile}
     fi
  TEXT1
done

May somebody help me please.

Thanks in advance.

Last edited by cgkmal; 10-07-2011 at 12:38 AM..

cgkmal

View Public Profile for cgkmal

Find all posts by cgkmal

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to get lines started with matched strings using sed or grep for loop?

I have a huge file and want to separate it into several subsets. The file looks like: C1 C2 C3 C4 ... (variable names) 1 .... 2 .... 3 .... : 22 .... 23 .... I want to separate the huge file using the column 1, which has numbers from 1 to 23 (but there are different amount of...

2. Shell Programming and Scripting

Replace Strings with sed or awk

Hello i need some help with the usage of sed. Situation : 2 textfiles, file.in , file.out In the first textfile which is called file.in are the words for the substitution. Every word is in a new-line like : Firstsub Secondsub Thridsub ... In the second textflie wich is called file.out is...

3. Shell Programming and Scripting

replace two character strings by two variables with sed command

Hello, I want to writte a script that replace two character strings by two variables with the command sed butmy solution doesn't work. I'm written this: sed "s/TTFactivevent/$TTFav/g && s/switchSLL/$SLL/g" templatefile. I want to replace TTFactivevent by the variable $TTFav, that is a...

4. Shell Programming and Scripting

Help with sed search&replace between two strings

Hi, i read couple of threads here on forum, and googled about what bugs me, yet i still can't find solution. Problem is below. I need to change this string (with sed if it is possible): This is message text that is being quoted to look like this: This is message text that is being quotedI...

5. Shell Programming and Scripting

Using sed to replace two different strings?

Hey everyone! Simple question - I am trying to use sed to replace two different strings. As it stands I can implement this as: sed -i 's/TIMEOUT//g' sed -i 's/null//g' And it works. However, is it possible to shrink that down into a single command? Will there be any performance benefits?

6. Shell Programming and Scripting

Using sed to replace strings if NOT found

Dear expert, I need an urgent help. I would like to update my /etc/ntp.conf file using sed. 1) if script find this string "127.127.1.0" then add the lone below #server 127.127.1.0 2) is script find this string "fudge 127.127.1.0 stratum 10" then add #fudge 127.127.1.0 stratum 10 ...

7. Programming

How to replace the complex strings from a file using sed or awk?

Dear All, I am having a requirement to find the difference between 2 files and generate a discrepancy report out of it as an html page. I prefer using diff -y file1 file2 since it gives user friendly layout to know any discrepancy in the record and unique records among the 2 file. Here's how it...

8. Shell Programming and Scripting

sed Find and Replace Text Between Two Strings or Words

I am looking for a sed in which I can recognize all of the text in between two indicators and then replace it with a place holder. For instance, the 1st indicator is a list of words "no|noone|havent" and the 2nd indicator is a list of punctuation ".|,|!".From a sentence such as "noone...

9. UNIX for Beginners Questions & Answers

sed find 2 strings and replace one

Hi Everyone, I want to find this 2 strings in a single line a file and replace the second string. this is the line i need to find <param name="user" value="CORE_BI"/> find user and CORE_BI and replace only CORE_BI with admin so finally the line should look like this. <param...

10. Shell Programming and Scripting

How to search and lossless replace strings using sed?

Hello, I would like to replace all occurencies of long data types by others (coresponding int) using 'sed' in the extensive source code of a software package written for 32 bit CPUs. I must use regular expressions to avoid wrong replacements like s/unsigned]+long/ulong/gLeaving out...

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to get lines started with matched strings using sed or grep for loop?

Discussion started by: AMBER

2. Shell Programming and Scripting

Replace Strings with sed or awk

Discussion started by: Kingbruce

3. Shell Programming and Scripting

replace two character strings by two variables with sed command

Discussion started by: POPO10

4. Shell Programming and Scripting

Help with sed search&replace between two strings

Discussion started by: angrybb

5. Shell Programming and Scripting

Using sed to replace two different strings?

Discussion started by: msarro

6. Shell Programming and Scripting

Using sed to replace strings if NOT found

Discussion started by: lamoul

7. Programming

How to replace the complex strings from a file using sed or awk?

Discussion started by: Badhrish

8. Shell Programming and Scripting

sed Find and Replace Text Between Two Strings or Words

Discussion started by: owwow14

9. UNIX for Beginners Questions & Answers

sed find 2 strings and replace one

Discussion started by: shajay12

10. Shell Programming and Scripting

How to search and lossless replace strings using sed?

Discussion started by: Mick P. F.