Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Reading XML file and print the values in the text file using Linux shell script Post 302950227 by sravanreddy on Wednesday 22nd of July 2015 09:14:40 AM
Old 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

Storing the values in text file using while loop in shell script

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

shell script to print particular column into text file

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

Print some results in a text file using script in linux

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

Shell Script to compare xml files and print output to a file

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

Reading a word from a text file into shell script

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

AWK/Shell script for reading text file

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

Passing values to an XML file from shell script

: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

Reading Xml file and print the values into the text file in columnwise?

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

How to write in other language in text/xml file by reading english text/xml file using C++?

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
DH_INSTALLXMLCATALOGS(1)					     Debhelper						  DH_INSTALLXMLCATALOGS(1)

NAME
dh_installxmlcatalogs - install and register XML catalog files SYNOPSIS
dh_installxmlcatalogs [debhelper options] [-n] DESCRIPTION
dh_installxmlcatalogs is a debhelper program that installs and registers XML catalog files. It complies with the Debian XML/SGML policy. The file debian/package.xmlcatalogs lists the local XML catalog files to be installed per package as well as the XML entities in those local XML catalog files that are to be registered in the XML catalog system. The local XML catalog file entries in that file should be of the form "local;source;dest", where the verbatim "local" indicates this is an entry for a local XML catalog file, "source" indicates where the local XML catalog resides in the source tree, and "dest" indicates the destination location for the local XML catalog under the package build area. "dest" should start with /usr/share/xml/. The entries for the XML entities to be registered in the package XML catalog file should be of the form "package;type;id;catalog", where the verbatim "package" indicates this is an entry for an XML entity to be registered in the package XML catalog file, "type" indicates the XML entity type (public, system, uri), "id" indicates the XML entity id, and "catalog" indicates the local XML catalog file. The entries for the XML entities to be registered in the root XML catalog file should be of the form "root;type;id", where the verbatim "root" indicates this is an entry for an XML entity to be registered in the root XML catalog file, "type" indicates the XML entity type (public, system, uri), and "id" indicates the XML entity id. If an entry for is to be registered identically in the root catalog and the package catalog file, you can use the form "root-and-package;type;id;catalog", where the verbatim "root-and-package" indicates this is an entry for an XML entity to be registered in both the root and package XML catalog files, "type" indicates the XML entity type (public, system, uri), "id" indicates the XML entity id, and "catalog" indicates the local XML catalog file. XML entity types are described in update-xmlcatalog(8). Using the "root" or "package" commands, a type of "public" will general "delegatePublic" statements in the applicable catalog file. Generally you will want to use the types "public" for any formal public identifiers, and "system" for any files on the local filesystem or URLs. "uri" is only used for non-local files which are not part of the external document subset, e.g., they are not used for entities or DTDs. dh_installxmlcatalogs automatically adds maintainer script snippets for the registration and unregistration of the listed XML entities in the XML catalog system (unless -n is used). A dependency on the xml-core package will be added to "${misc:Depends}", so be sure to use that variable in the file debian/control. See dh_installdeb(1) for an explanation of Debhelper maintainer script snippets. OPTIONS
-n, --noscripts Do not modify postinst/postrm/prerm scripts. NOTES
Note that this command is not idempotent. "dh_clean -k" should be called between invocations of this command. Otherwise, it may cause multiple instances of the same text to be added to maintainer scripts. SEE ALSO
debhelper(7) /usr/share/doc/xml-core/ AUTHOR
Ardo van Rangelrooij <ardo@debian.org> Adam Di Carlo <aph@debian.org> perl v5.14.2 2012-09-10 DH_INSTALLXMLCATALOGS(1)
All times are GMT -4. The time now is 10:49 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy