UNIX for Beginners Questions & Answers

Dear Unix guru,

I have a .XML file which is being used to load data to oracle. This file comes on unix box and one of the tag in xml is oracle key word. I want to find that tag and replace with new tag on the fly
For example
I will get one of the tag in xml is as below

Code:

<from>Test Test 123</from>

since "from" is oracle key word i am having difficulties to read this so i want to replace this as below

Code:

<from_msg> Test Test 123</from_msg>

I also want to check various point like
<from > , < from > , < from>
i guess there can be space between tag and text.

I am not at all unix guy so can write any shell scripts, Any small scripts would really help me to keep moving

Thanks for the understanding

Moderator's Comments:

Please use CODE tags as required by forum rules! You have SIX infractions by now for not using them; it's just because you were absent for >2 years that this note has become a small informal reminder only!

Is that space in front of "Test" in the desired output on purpose or is it a typo? You didn't say you want one in the written spec.

Code:

sed -r 's/< *from *>([^<]*)<\/ *from *>/<from_msg>\1<\/from_msg>/g' file
<from_msg>Test Test 123</from_msg>

Hi

I am checking for space just because typo ,so that job would not fail

Any suggestions

Hi All,

Can any body help me with the below error

Code:

 sed -r 's/< *from *>([^<]*)<\/ *from *>/<from_msg>\1<\/from_msg>/g' message.xml>output.xml

output

Code:

sed: illegal option -- r

Moderator's Comments:

Please use CODE tags as required by forum rules!

That option is needed for sed to understand EREs; pls check if -E will do instead.

Hi

Not working

Code:

 sed -E's/< *from *>([^<]*)<\/ *from *>/<from_msg>\1<\/from_msg>/g' message.xml>output.xml

Code:

sed: illegal option -- E

Moderator's Comments:

Please use CODE tags as required by forum rules!

Is there a space missing between -E and the ' or is that a typo?
Howsoever, try leaving out any option but escape the parentheses.