Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: XML-Text Parsing Using shell scripting
Top Forums Shell Programming and Scripting XML-Text Parsing Using shell scripting Post 302710109 by pamu on Thursday 4th of October 2012 02:15:07 AM
Old 10-04-2012
something like this..
Code:
$awk -F '[:"<>]' -v VM="Equipment,AntennaUnitGroup,AntennaNearUnit,RetSubUnit" '{split(VM,M,",")}
/SubNetwork/{gsub(" id=","=",$0);S=$3$4;}
/MeContext/{gsub(" id=","=",$0);P=$3$4}
/ManagedElement/{gsub(" id=","=",$0);K=$3$4;a=0}
/VsDataContainer id=/{if(T){a++;T=T","M[a]"="$4;}else{a++;T=M[a]"="$4}}
/<es:el>/{if(a==4){print S,P,K,T"\t"$4;a=0;T=""}else{print S,P,K,T,M[4]"=1""\t"$4;a=0;T=""}} ' OFS=, file

SubNetwork=ONRM_ROOT_MO_R,MeContext=LP101,ManagedElement=1,Equipment=1,AntennaUnitGroup=1,AntennaNearUnit=1,RetSubUnit=1        80
SubNetwork=ONRM_ROOT_MO_R,MeContext=LP101,ManagedElement=1,Equipment=2,AntennaUnitGroup=1,AntennaNearUnit=1,RetSubUnit=1        30
SubNetwork=ONRM_ROOT_MO_R,MeContext=LP101,ManagedElement=1,Equipment=3,AntennaUnitGroup=1,AntennaNearUnit=1,RetSubUnit=1        80
SubNetwork=ONRM_ROOT_MO_R,MeContext=LP102,ManagedElement=1,Equipment=1,AntennaUnitGroup=1,AntennaNearUnit=1,RetSubUnit=1        20
SubNetwork=ONRM_ROOT_MO_R,MeContext=LP102,ManagedElement=1,Equipment=2,AntennaUnitGroup=1,AntennaNearUnit=1,RetSubUnit=1        100
SubNetwork=ONRM_ROOT_MO_R,MeContext=LP102,ManagedElement=1,Equipment=3,AntennaUnitGroup=1,AntennaNearUnit=1,RetSubUnit=1        80
SubNetwork=ONRM_ROOT_MO_R,MeContext=LP103,ManagedElement=1,Equipment=1,AntennaUnitGroup=1,AntennaNearUnit=1,RetSubUnit=1        80
SubNetwork=ONRM_ROOT_MO_R,MeContext=LP103,ManagedElement=1,Equipment=2,AntennaUnitGroup=1,AntennaNearUnit=1,RetSubUnit=1        100
SubNetwork=ONRM_ROOT_MO_R,MeContext=LP103,ManagedElement=1,Equipment=3,AntennaUnitGroup=1,AntennaNearUnit=1,RetSubUnit=1        90

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

XML parsing through shell scritps

Hi, Am new to scripting. :) Am trying to figure out whether can i use bash scripting to parse an xml file. Parsing is not just pulling out information according to the pattern but its more of a generic parsing. I should identify the xml hierarchy and pull out information accordingly. It's not a... (2 Replies)
Discussion started by: karthikvela
2 Replies

2. Shell Programming and Scripting

Parsing XML using Shell Script

Hello, I'm a starting shell scripter and no Perl knowledge. I've trying to do this for a while: I want to parse an XML file and get certain data out of it and write that data into a CSV file, all this using Shell Scripting (in Bash). Or Perl without any XML Parser/Interpreter (if possible). ... (1 Reply)
Discussion started by: Kage Musha
1 Replies

3. Shell Programming and Scripting

XML parsing in a shell script.

Below is a XML I have... <?xml version="1.0" encoding="UTF-8" ?> <component xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="urn:XXXXX-www-Install-Manifest manifest.xsd" xmlns="urn:qqqqq-Install-Manifest" name="OM" ... (1 Reply)
Discussion started by: dashok.83
1 Replies

4. Shell Programming and Scripting

Shell script for XML code parsing.

Please help me to create a shell script that can parse the below XML and send a string back adding all XML values.:) <RequestBillsRsp... (1 Reply)
Discussion started by: xtatic
1 Replies

5. Shell Programming and Scripting

XML parsing using shell script

I have a xml file like this <bul:collectionStrategy name="strategy1"> <bul:collectionTemplateGroup name="15min group"/> <bul:collectionTemplateGroup name="hourly group"/> </bul:collectionStrategy> <bul:CollectionTemplateGroup name="hourly group" > ... (2 Replies)
Discussion started by: LavanyaP
2 Replies

6. Shell Programming and Scripting

XML to Text file Parsing Using shell scripting

Hi folks, Need some help with XML to text file parsing , the following is the content of the XML File. <xn:SubNetwork id="SNJNPRZDCR0R03"> <xn:MeContext id="PRSJU0005"> <xn:VsDataContainer id="PRSJU0005"> <xn:attributes> ... (6 Replies)
Discussion started by: tech_frk
6 Replies

7. Shell Programming and Scripting

Parsing XML using shell script

Well, issue is i have to parse this script to get the VERSION: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"> <plist version="1.0"> <dict> <key>CFBundleAllowMixedLocalizations</key> ... (9 Replies)
Discussion started by: zorosinister
9 Replies

8. Solaris

XML to Text file Parsing Using shell scripting

Hi, I want to parse an XML File using Shell Script preferably by using awk command, I/P file is : <gn:ExternalGsmCell id="016P3A"> <gn:attributes> <gn:mnc>410</gn:mnc> <gn:mcc>310</gn:mcc> <gn:lac>8016</gn:lac> ... (2 Replies)
Discussion started by: tech_frk
2 Replies

9. Shell Programming and Scripting

Scripting Language for Parsing XML

Hello, I want to know which shell scripting language (like AWk, Perl or any other) is the best for parsing and editing 1) space or Comma Separated Datsets 2) XML type Datasets. (1 Reply)
Discussion started by: ajayram
1 Replies

10. Shell Programming and Scripting

Parsing custom data into xml in Shell

Hi , I have data as below in a text file { 'AAA' => { 'A1' => 'a1 comment', 'A2' => 'a2 comment' }, 'BBB' => { 'B1' => 'b1 comment' }, 'CCC' => { 'C1' => 'c1 comment', 'C2' => 'c2 comment', 'C3' => 'c3 comment' 'C4' => 'c4... (2 Replies)
Discussion started by: vivek d r
2 Replies

LEARN ABOUT DEBIAN

cgi::xml

XML(3pm)						User Contributed Perl Documentation						  XML(3pm)

NAME

       CGI::XML - Perl extension for converting CGI.pm variables to/from XML

SYNOPSIS

	 use CGI::XML;
	 $q = new CGI::XML;

	 # convert CGI.pm variables to XML
	 $xml = $q->toXML;
	 $xml = $q->toXML($root);

	 # convert XML to CGI.pm variables
	 $q->toCGI($xml);

DESCRIPTION

       The CGI::XML module converts CGI.pm variables to XML and vice versa.

       CGI::XML is a subclass of CGI.pm, so it reads the CGI variables just as CGI.pm would.

METHODS

       $q = new CGI::XML
	   creates a new instance of CGI::XML. You also have access to all of the methods in CGI.pm.

       $q->toXML([$root])
	   where $root is an optional parameter that specifies the root element. By default, toXML will not return a root element.

       $q->toCGI($xml)
	   where $xml is the XML you would like to convert to CGI.pm parameters. Values in the XML will overwrite any existing values if they
	   exist.

NOTE

       CGI::XML does not currently handle multiple selections passed from HTML forms. This will be added in a future release.

AUTHOR

       Jonathan Eisenzopf <eisen@pobox.com>

CONTRIBUTORS

       David Black <dblack@candle.superlink.net>

SEE ALSO

       perl(1), XML::Parser(3).

perl v5.8.8							    2004-12-05								  XML(3pm)
All times are GMT -4. The time now is 09:10 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy