Parsing Values from XML

Shell Programming and Scripting
1

Hi all,

Can anyone help me out in parsing values from the xml in shell script below..

<DropDB>
        <DBName>RMDatabase</DBName>
        <UName>root</UName>
        <PWord>test</PWord>
</DropDB>

I need the values RMDatabase , root and test alone ... :wall:

Thanks in advance :slight_smile:

-Selva

2

Hi

$ awk -F '[<>]' 'NF>3{print $3}' file
RMDatabase
root
test

Guru.

3 
# awk '/^  */{print $3}' FS='[<>]*' file
RMDatabase
root
test

# sed -n '/^  */s/ *[></]*\|[A-Z]*Name\|PWord//pg' file
RMDatabase
root
test

# cut -d'<' -f2 file|cut -d'>' -f2

RMDatabase
root
test



# sed -n '/Drop/!s/.*>\(.*\)<.*/\1/p' file
RMDatabase
root
test

# while read -r line ; do expr "$line" : '<.*>\(.*\)</.*>';done <file

RMDatabase
root
test

regards
ygemici

1 Like