extract xml tag value from the file to Variable

Question

I Have a file. where I need to extract dataTemplate name. need a value in datalob=XXPFARCUDO_DATA

<?xml version="1.0" encoding="windows-1252" ?> <dataTemplate name="XXPFARCUDO_DATA" description="Ctrole de cohnce des clits doeux et conteeux" Version="1.0"> <parameters> <parameter name="P_SOCIETE" dataType="character"/> </parameters> . . . . </dataTemplate> 

I have code but it is not working

filename='XXPFARCUDO_DATA.xml' LOBCODE=$(sed -n 's:.*<dataTemplate name="\(.*\)" description=".*:\1:p' "${filename}") echo " --> ${LOBCODE} " 

it result is not correct

 --> XXPFARCUDO_DATA▒role de cohnce des clits doeux et conteeux" Version="1.0"> 

Answer 1

Assuming that the XML is well formed, such as

<?xml version="1.0" encoding="windows-1252"?> <dataTemplate name="XXPFARCUDO_DATA" description="Ctrole de cohnce des clits doeux et conteeux" Version="1.0"> <parameters> <parameter name="P_SOCIETE" dataType="character"/> </parameters> </dataTemplate> 

You would get the value of the attribute name in the dataTemplate node through XMLStarlet like this:

LOBCODE=$( xml sel -t -v '/dataTemplate/@name' "$filename" ) 

XMLStarlet is sometimes installed as xmlstarlet rather than as xml.

Using xmllint:

LOBCODE=$( xmllint --xpath 'string(/dataTemplate/@name)' "$filename" ) 

---

Please, don't try to parse XML using sed. It is error prone and fragile.