[SOLVED] Need to find all contents of XML tag if certain parameter value match

addy54 · 05-06-2016, 04:23 AM

Hello All,

I've below test XML and I am trying to get whole tag parameters in which CONFIRM="1"

Quote:

<APPLICATION=""

APR="1"

AUG="1"

CHANGE_DATE="20160410"

CHANGE_TIME="045325"

CHANGE_USERID="system"

CONFIRM="0"

CREATION_DATE="20100520"

CREATION_TIME="210945"

CRITICAL="0"

CYCLIC="0"

DAYSCAL="CTMCAL5N"

DAYS_AND_OR="OR"

DEC="1"

FEB="1"

HOSTNAME="abc.xyz.com"

SHIFTNUM="+00"

SYSDB="0">

<SHOUT TIME="0800"/>

<\APPLICATION>

<APPLICATION=""

APR="1"

AUG="1"

CHANGE_DATE="20160410"

CHANGE_TIME="045331"

CHANGE_USERID="system"

CONFIRM="1"

CREATION_DATE="20100520"

CREATION_TIME="210945"

CRITICAL="0"

CYCLIC="0"

DAYSCAL="CTMCAL5N"

DAYS_AND_OR="OR"

DEC="1"

FEB="1"

HOSTNAME="abc.pqr.com"

SHIFTNUM="+00"

SYSDB="0">

<SHOUT TIME="0800"/>

<\APPLICATION>

So in above example I should get all values of tag <Application ... >

I am trying below command but it is not working

cat test.xml | sed -n '/CONFIRM="1"/ s/<APPLICATION .*>\(.*\)<\APPLICATION>/&/p'

Can somebodey help me here?

syg00 · 05-06-2016, 06:04 AM

Parsing xml using shell tools is a mugs game. Can be done, but you have to be very particular in what you ask for. Most of the time you get what you asked for. Which is nothing like what you thought you asked for.

Use a xml aware tool - there are innumerable threads about this - try some searches. xmllint might be a start, or cpan for perl.

addy54 · 05-06-2016, 06:41 AM

Thanks a lot

I've used xmllint and it worked.

echo 'cat //APPLICATION[@CONFIRM="1"]' | xmllint --shell test.xml