Bash script to find first occurrence of a string after an URL

Question

I can't find out how to solve this simple problem:

I have an XML file and an an URL as a parameter in the script: $URL.

I need to find the string "NO_CODE" just after the $URL (which could be: http://www.webpage2.com) and replace this string with: CODE_OK.

There is any easy way to do this?

<Row ss:AutoFitHeight="0">
    <Cell ss:StyleID="s65" ss:HRef="http://www.webpage1.com"><Data
      ss:Type="String">Name of the webpage 1</Data></Cell>
    <Cell><Data ss:Type="String">NO_CODE</Data></Cell>
   </Row>
   <Row ss:AutoFitHeight="0">
    <Cell ss:StyleID="s65" ss:HRef="http://www.webpage2.com"><Data
      ss:Type="String">Name of the webpage 2</Data></Cell>
    <Cell><Data ss:Type="String">NO_CODE</Data></Cell>
   </Row>
   <Row ss:AutoFitHeight="0">
    <Cell ss:StyleID="s65" ss:HRef="http://www.webpage3.com"><Data
      ss:Type="String">Name of the webpage 3</Data></Cell>
    <Cell><Data ss:Type="String">NO_CODE</Data></Cell>
   </Row>

Thanks very much.

score 0 · Accepted Answer · answered Jul 04 '14 at 09:41

Through GNU awk and sed,

$ awk -v RS="</Row>" '/http:\/\/www\.webpage2\.com/{sub(/NO_CODE/,"CODE_OK")}1' ORS="</Row>" file | sed '$d'
<Row ss:AutoFitHeight="0">
    <Cell ss:StyleID="s65" ss:HRef="http://www.webpage1.com"><Data
      ss:Type="String">Name of the webpage 1</Data></Cell>
    <Cell><Data ss:Type="String">NO_CODE</Data></Cell>
   </Row>
   <Row ss:AutoFitHeight="0">
    <Cell ss:StyleID="s65" ss:HRef="http://www.webpage2.com"><Data
      ss:Type="String">Name of the webpage 2</Data></Cell>
    <Cell><Data ss:Type="String">CODE_OK</Data></Cell>
   </Row>
   <Row ss:AutoFitHeight="0">
    <Cell ss:StyleID="s65" ss:HRef="http://www.webpage3.com"><Data
      ss:Type="String">Name of the webpage 3</Data></Cell>
    <Cell><Data ss:Type="String">NO_CODE</Data></Cell>
   </Row>

score 0 · Answer 2 · 2014-07-04T11:57:22.327

0

Another awk way

awk '/www.webpage2.com/{x=1}x{if(sub(/NO_CODE/,"CODE_OK"))x=0}1' file

with variable

awk -vy="$website" '$0~y{x=1}x{if(sub(/NO_CODE/,"CODE_OK"))x=0}1' file

edited Jul 04 '14 at 11:57

answered Jul 04 '14 at 10:11

And what about using a variable for the website, for example: WEBPAGE="http://webpage2.com/section1/section2/" And then passing the variable to awk with the website? Thansk. – user3139207 Jul 04 '14 at 11:10
@user3139207 you could do this through awk's `-v` parameter. – Avinash Raj Jul 04 '14 at 11:15
But how to integrate it into this example? Any help? – user3139207 Jul 04 '14 at 11:18
@user3139207 ask it as another question to get immediate response. – Avinash Raj Jul 04 '14 at 11:49

Bash script to find first occurrence of a string after an URL

2 Answers2