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 ULTRIX

term

term(7) 						 Miscellaneous Information Manual						   term(7)

Name
       term - conventional names for terminals

Description
       Certain commands use these terminal names. They are maintained as part of the shell environment. For further information, see and

       adm3a	 Lear-Siegler ADM-3a
       2621	 Hewlett-Packard HP262? series terminals
       hp	 Hewlett-Packard HP264? series terminals
       c100	 Human Designed Systems Concept 100
       h19	 Heathkit H19
       mime	 Microterm mime in enhanced ACT IV mode
       1620	 Diablo 1620 (and others using HyType II)
       300	 DASI/DTC/GSI 300 (and others using HyType I)
       33	 Teletype Model 33
       37	 Teletype Model 37
       43	 Teletype Model 43
       735	 Texas Instruments TI735 (and TI725)
       745	 Texas Instruments TI745
       dumb	 Terminals with no special features
       dialup	 A terminal on a phone line with no known characteristics
       network	 A terminal on a network connection with no known characteristics
       4014	 Tektronix 4014
       vt52	 Digital Equipment Corp. VT52
       vt100	 Digital Equipment Corp. VT100
       vt200	 Digital Equipment Corp. VT200 - used on VT220, VT240
       vt300	 Digital Equipment Corp. VT300 - used on VT330, VT340
       xterm	 xterm terminal emulator, X window system

       See for an up-to-date and locally correct list.	See for more information on

       Commands  whose	behavior may depend on the terminal, either consult TERM in the environment, or accept arguments of the form where term is
       one of the names given above.

See Also
       clear(1), ex(1), more(1), nroff(1), plot(1g), sh(1), stty(1), tabs(1), tset(1), ul(1), termcap(3x), termcap(5), environ(7)

																	   term(7)
All times are GMT -4. The time now is 01:16 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy