UNIX for Dummies Questions & Answers

hi guys, i want help... Reding XML file and print the values into the text file using linux shell script file as per below xml file

<sequence>
<Filename>aldorzum.doc</Filename>
<DivisionCode>US</DivisionCode>
<ContentType>Template</ContentType>
<ProductCode>VIMZIM</ProductCode>
</sequence>
<sequence>
<Filename>alozyme.doc</Filename>
<DivisionCode>CA</DivisionCode>
<ContentType>Standard</ContentType>
<ProductCode />
</sequence>
<sequence>
<Filename>ASER.doc</Filename>
<DivisionCode>SA</DivisionCode>
<ContentType>Template</ContentType>
<ProductCode>ENCLOSER</ProductCode>
</sequence>

I want Out put in sample.text file below manner

Filename ,DivisionCode , Product Code ,ContentType
aldorzum.doc ,US ,VIMZIM , Template
alozyme.doc , CA , , Standard
ASER.doc ,SA , ENCLOSER ,Template

I WANT ABOVE OUT PUT IN TEXT FILE WHILE READING XML FILE USING LINUX SHELL SCRIPT

PLEASE ANY ONE HELP ME...I NEED URGENT THAT LINUX SHELL SCRIPT
FOR READING XML FILE AND PRINT THE VALUES INTO THE TEXT FILE COLUMN WISE...
IF PRODUCT CODE VALUE IS EMPTY OR NOT EXIST JUST PRINT EMPTY SPACE.


i used below script not working according to my requirement.

$ nawk -F"[\"<>]" '/Filename/{id=$3}/DivisionCode/{m=$3}/ProductCode/{mc=$3}/ContentType/{ct=$3} {if(id && m && mc && ct){print id,m,mc,ct; id=m=mc=ct=0;}}' DocumentExportMetaData_20150705T000008.xml >sample.txt

but i get belowoutput
aldorzum.doc ,US ,VIMZIM ,Template
alozyme.doc , CA , ,
, Standard
ASER.doc , SA , ENCLOSER , Template
pleasure.doc CT
, TEMPLATE

I GOT ABOVE RESULTS WHILE USING MY SHELL SCRIPT..HERE IF PRODUCTCODE VALUE IS NOT EXIST THEN CONTENTTYPE VALUE IS PRINTED IN NEXT FILE ...
BUT I NEED IF PRODUCT CODE VALUE IS NOTEXIST OR NULL VALUE THEN LEAVE SPACE INSTEAD OF PRODUCTCODE PLACE THEN PRINT CONTENTTYPE IN NEXT COLUMN


Please any one help me...for my required output

Bumping up posts or double posting is not permitted in these forums.

Please read the rules, which you agreed to when you registered, if you have not already done so.

You may receive an infraction for this. If so, don't worry, just try to follow the rules more carefully. The infraction will expire in the near future

Thank You.

The UNIX and Linux Forums.