07-22-2015
Reading XML file and print the values in the text file using Linux shell script
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
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Frdz
while read line
do
name=`echo $line | cut -d' ' -f 1 `
password=`echo $line | cut -d`-` -f 2`
name > logfile.txt
password > logfile.txt
done < list.txt
When it is run, am getting last values in list.txt file only,it is not storing lall the list entry values. How can i... (5 Replies)
Discussion started by: KiranKumarKarre
5 Replies
2. Shell Programming and Scripting
hi everyone,
i need a script which would just print column into a text file
nmap 10.226.112.222
PORT STATE SERVICE
7/tcp open echo
13/tcp open daytime
22/tcp open ssh
23/tcp open telnet
37/tcp open time
1100/tcp open unknown
above nmap command gives us open ports on that IP. can... (6 Replies)
Discussion started by: anand121
6 Replies
3. Shell Programming and Scripting
hello everyone,
i really need your help to write a script which would just print following kind of result into a text file (result.txt)
XYZ test Results
ID: <unique-id> Date: <date>
-------------------------------------------------
| Task | Result | Time |... (3 Replies)
Discussion started by: viriimind
3 Replies
4. UNIX for Advanced & Expert Users
All,
PLease can you help me with a shell script which can compare two xml files and print the difference to a output file.
I have attached one such file for you reference.
<Group>
<Member ID=":Year_Quad:41501" childCount="4" fullPath="PEPSICO Year-Quad-Wk : FOLDER.52 Weeks Ending Dec... (2 Replies)
Discussion started by: kanthrajgowda
2 Replies
5. Shell Programming and Scripting
Hi,
I am new to shell programming.I need to write a script that would accept a word from each line fo an input text file.Can anyone help me with this?Exact requirement: word1 word2 word3 (separated by space) .Now I need word3 from each such line in the text file.
Thanks in Advance,
Manish (3 Replies)
Discussion started by: manish007
3 Replies
6. Shell Programming and Scripting
Hello,
I have a text file which has list of SQL Commands, from where I have grepped the lines where there is a specific string:
grep <string> <file1> >> <file2>
A sample of the file2 is:
INSERT INTO PS_PWC_SP_ERN_DATA SELECT A.EMPLID ,B.COMPANY ,B.PAYGROUP ,
B.OTH_PAY FROM... (7 Replies)
Discussion started by: suddhasatwa_bha
7 Replies
7. Shell Programming and Scripting
:wall: Hi,
I have an XML file with 5 tags. I need to pass values to the XML file from a shell script that will replace values in 2 of the tags. I cannot hardcode the tag values in XML and use replace command in script as the values are likely to change.
Please help !!!!!!!!!!! (2 Replies)
Discussion started by: Monalisaa
2 Replies
8. 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>... (4 Replies)
Discussion started by: sravanreddy
4 Replies
9. Programming
Hello Team,
I have 2 files.one contains english text and another contains Japanese. so i have to read english text and replace the text with Japanesh text in third file.
Basically, I need a help to write japanese language in text/xml file.I heard wstring does this.Not sure how do i write... (2 Replies)
Discussion started by: SA_Palani
2 Replies
LEARN ABOUT DEBIAN
graphviz::xml
GraphViz::XML(3pm) User Contributed Perl Documentation GraphViz::XML(3pm)
NAME
GraphViz::XML - Visualise XML as a tree
SYNOPSIS
use GraphViz::XML;
my $graph = GraphViz::XML->new($xml);
print $g->as_png;
DESCRIPTION
This module makes it easy to visualise XML as a tree. XML is hard for humans to grasp, especially if the XML is computer-generated. This
modules aims to visualise the XML as a graph in order to make the structure of the XML clear and to aid in understanding the XML.
XML elements are represented as diamond nodes, with links to elements within them. Character data is represented in round nodes.
Note that the XML::Twig module should be installed.
METHODS
new
This is the constructor. It takes one mandatory argument, which is the XML to be visualised. A GraphViz object is returned.
my $graph = GraphViz::XML->new($xml);
as_*
The XML can be visualised in a number of different graphical formats. Methods include as_ps, as_hpgl, as_pcl, as_mif, as_pic, as_gd,
as_gd2, as_gif, as_jpeg, as_png, as_wbmp, as_ismap, as_imap, as_vrml, as_vtx, as_mp, as_fig, as_svg. See the GraphViz documentation for
more information. The two most common methods are:
# Print out a PNG-format file
print $g->as_png;
# Print out a PostScript-format file
print $g->as_ps;
BUGS
GraphViz tends to reorder the nodes. I hope to find a work around soon (possibly with ports).
AUTHOR
Leon Brocard <acme@astray.com>
COPYRIGHT
Copyright (C) 2001, Leon Brocard
This module is free software; you can redistribute it or modify it under the same terms as Perl itself.
perl v5.14.2 2012-04-02 GraphViz::XML(3pm)