Shell Programming and Scripting

Hi

I have a xml file with below data...have to find the length of the filedvalues...


<?xml version="1.0" encoding="ISO-8859-15" standalone="no"?><abc xmlns:xsi="http://www.w3.org/2000/XMLSchem
a-instance"><FileHeader><FileName>VertSvcsDSL20081202103929.XML</FileName><NumOrderRecs>27</NumOrderRecs><NumDetailRecs>46</NumDetailRecs></FileHeader><OrderHeaderList><Order><CRMOrderID>0</CRMOrderID><CRMSvcOrderID>0</CRMSvcOrderID><UDCRMSONum>0</UDCRMSONum>
filename , NumOrderRecs and NumDetailRecs ... are field names

so need length of the data in between tags for ex: length of VertSvcsDSL20081202103929.XML

any help in this

OK - can only give you a general type reply - this will require AWK.

Make your RS=">", that will break the input into lines containing the different fields.
Then you would check to see if it is a start tag or or end tag field indicator by the last character being a "/" -

When you fine a start-tag, the next record is your input value for that tag - unless it is an end-tag.

Some of the things to be carefull for in XML

It could be unicode based - what will you do then - awk and most UNIX utilities are bad at handling binary zeroes.

I have seen XML files where it is a 25000 character single line. Perfectly leagal to XML, bad for vi on UNIX. That is the reason for the Field Separator definition to awk.

in you example - filename looks like it contains two elements, and not other data.

hi, not very sure what's your defination for field.

And also you are expecting length of filedname or fieldvalue.

Anyway, below may help you a little.

input:

Code:

<FileName>VertSvcsDSL20081202103929.XML</FileName><NumOrderRecs>27</NumOrderRecs><NumDetailRecs>46</NumDetailRecs>

output:

Code:

FileName -- VertSvcsDSL20081202103929.XML -- FileName
NumOrderRecs -- 27 -- NumOrderRecs
NumDetailRecs -- 46 -- NumDetailRecs

code:

Code:

open FH,"<b.txt";
my @arr=<FH>;
close FH;
foreach(@arr){
	while(m/<(.*?)>(.*?)<\/\1>/){
		print $1," -- ",$2," -- ",$1,"\n";
		$_=$';
	}
}

i need to find out the fieldvalue length means data length which is in between tags