Shell Programming and Scripting

Hi,

I have a input xml file like this

<postalAddress:>379 PROSPECT ST </postalAddress:>
<street:>STE B </street:>
<l:>TORRINGTON </l:>
<st:>CT</st:>
<postalCode:>067905238</postalCode:>
<telephoneNumber:>9999999999</telephoneNumber:>
<facsimileTelephoneNumber:>9999999999</facsimileTelephoneNumber:>

<postalAddress:>579 RARITAN RD </postalAddress:>
<street:>STE A </street:>
<l:>ROSELLE </l:>
<st:>NJ</st:>
<postalCode:>072039999</postalCode:>
<telephoneNumber:>9999999999</telephoneNumber:>
<facsimileTelephoneNumber:>9999999999</facsimileTelephoneNumber:>


and I need my ouput to be


postalAddress:379 PROSPECT ST
street:STE B
l:TORRINGTON
st:CT
postalCode:067905238
telephoneNumber:9999999999
facsimileTelephoneNumber:9999999999

postalAddress:579 RARITAN RD
street:STE A
l:ROSELLE
st:NJ
postalCode:072039999
telephoneNumber:9999999999
facsimileTelephoneNumber:9999999999

Not the most elegant of code but it does what you wnat:

Code:

$ cat address.xml
<postalAddress:>379 PROSPECT ST </postalAddress:>
<street:>STE B </street:>
<l:>TORRINGTON </l:>
<st:>CT</st:>
<postalCode:>067905238</postalCode:>
<telephoneNumber:>9999999999</telephoneNumber:>
<facsimileTelephoneNumber:>9999999999</facsimileTelephoneNumber:>
$ cat ./gettextfromxml.sh
#!/bin/bash

awk -F"<" '{ print $2 }' address.xml | sed -e 's/>//'
$ ./gettextfromxml.sh
postalAddress:379 PROSPECT ST 
street:STE B 
l:TORRINGTON 
st:CT
postalCode:067905238
telephoneNumber:9999999999
facsimileTelephoneNumber:9999999999
$

just one awk command will do. you can do substitution in awk using either gsub or sub.

It can also be done using a sed oneliner i.e.

Code:

sed -n 's/<\(.*:\)>\([[:print:]][^<]*\).*$/\1\2/p' file

Just awk

Code:

awk -F'[<|>]' '{print $2,$3}' file

Code:

sed 's/<\([^>]*\)>\(.*\)<\/\1>/\1\2/' filename