Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help with parsing xml file
Top Forums Shell Programming and Scripting Help with parsing xml file Post 302961922 by Aia on Sunday 6th of December 2015 04:34:41 PM
Old 12-06-2015
If you would like to have it formatted as post #3, the following is a possible Perl solution:

Code:
#!/usr/bin/env perl
use strict;
use warnings;

my @group = ();
my $groupnum = 0;

while(<>){
    if(/<iwgroup name/) {
        my ($name, $description) = /\bname="([^"]*).+\bdescription="([^"]*)/;
        $groupnum++;
        my $meta = "Groupname$groupnum: $name\nDescription: $description\n";
        push @group, [$meta];
        next;
    }
    if(exists $group[0]){
        if(/<user name="([^"]*)/){
            push @{$group[1]}, $1;
        }
    }
    if(/<\/iwgroup>/){
        print "\n" unless $groupnum == 1;
        print "$group[0]->[0]Users: ", join(", ", @{$group[1]}), "\n";
        @group = ();
    }
}

Save as report.pl
Run as perl report.pl ajayakunuri.file > ajayakunuri.report

Code:
perl report.pl ajayakunuri.file
Groupname1: AEapproval
Description: group for AE approval
Users: iwov, m161595, m594670, m803051

Groupname2: OES_EMAIL
Description: OES email group with permission to start oes pool workflow
Users: iwov, m123053, m270857, m363836

This User Gave Thanks to Aia For This Post:
ajayakunuri
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Parsing xml file using Sed

Hi All, I have this(.xml) file as: <!-- define your instance here --> <instance name='ins_C2Londondev' user='' group='' fullname='B2%20-%20London%20(dev)' > <property> </property> </instance> I want output as: <!-- define your instance here --> <instance... (3 Replies)
Discussion started by: kapilkinha
3 Replies

2. Shell Programming and Scripting

XML file parsing using script

Hi I need some help with XML file parsing. I have an XML file with the below tag, I need a script to identify the value of srvcName which is this case is "AAA srvc name". I need to put contents of this value which is AAA srvc and name into different variables using an array and then reformat it... (6 Replies)
Discussion started by: zmfcat1
6 Replies

3. UNIX for Dummies Questions & Answers

Help parsing a XML file ....

Well I have read several threads on the subject ... but being a newbie like me makes it hard to understand ... What I need is the following: Input data: ------- snip --------- <FavouriteLocations> <FavouriteLocations class="FavouriteList"><Item... (6 Replies)
Discussion started by: misak
6 Replies

4. Shell Programming and Scripting

Parsing xml file

hi guys, great help to the original question, can i expand please? i have large files filled with blocks like this <Placemark> network type: hot line1 line2 line3 <styleUrl>red.png</styleUrl> </Placemark> <Placemark> network type: cold line1 line2 line3... (3 Replies)
Discussion started by: garvald
3 Replies

5. Shell Programming and Scripting

Help in parsing xml file (sed/nawk)

I have a large xml file as shown below: <input> <blah> <blah> <atr="blah blah value = ""> <blah> <blah> </input> ..2nd chunk... ..3rd chunk... ...4th chunk... All lines between <input> and </input> is one 'order' and this 'order' is repeated... (14 Replies)
Discussion started by: shekhar2010us
14 Replies

6. Shell Programming and Scripting

parsing xml file

Hello! We need to parse weblogic config.xml file and display rows in format: machine:listen-port:name:application_name In our enviroment the output should be (one line for every instance): Crm-Test-Web:8001:PIA:peoplesoft Crm-Test-Web:8011:PIA:peoplesoft... (9 Replies)
Discussion started by: annar
9 Replies

7. Shell Programming and Scripting

Parsing an XML file

Hello, I have the following xml file as an input. <?xml version="1.0" encoding="UTF-8"?> <RECORDS PS3_VERSION="1104_01"><RECORD> <POI_ID>931</POI_ID> <SUPPLIER_ID>2</SUPPLIER_ID> <POI_PVID>997920846</POI_PVID> <DB_ID>1366650925</DB_ID> <REGION>H1</REGION> <POI_NAME NAME_TYPE="Official"... (4 Replies)
Discussion started by: ramky79
4 Replies

8. Shell Programming and Scripting

Help in parsing XML output file in perl.

Hi I have an XML output like : <?xml version="1.0" encoding="ISO-8859-1" ?> - <envelope> - <body> - <outputGetUsageSummary> - <usgSumm rerateDone="5"> - <usageAccum accumId="269" accumCaptn="VD_DP_AR" inclUnits="9999999.00" inclUnitsUsed="0.00" shared="false" pooled="false"... (7 Replies)
Discussion started by: rkrish
7 Replies

9. Shell Programming and Scripting

XML: parsing of the Google contacts XML file

I am trying to parse the XML Google contact file using tools like xmllint and I even dived into the XSL Style Sheets using xsltproc but I get nowhere. I can not supply any sample file as it contains private data but you can download your own contacts using this script: #!/bin/sh # imports... (9 Replies)
Discussion started by: ripat
9 Replies

10. UNIX for Dummies Questions & Answers

Parsing XML file

I want to parse xml file sample file....... <name locale="en">my_name<>/name><lastChanged>somedate</lastChanged><some more code here> <name locale="en">tablename1<>/name><lastChanged>somedate</lastChanged> <definition><dbquery><sources><sql type="cognos">select * from... (10 Replies)
Discussion started by: ms2001
10 Replies

LEARN ABOUT DEBIAN

stag-autoschema

STAG-AUTOSCHEMA(1p)					User Contributed Perl Documentation				       STAG-AUTOSCHEMA(1p)

NAME

       stag-autoschema - writes the implicit stag-schema for a stag file

SYNOPSIS

	 stag-autoschema -w sxpr sample-data.xml

	 stag-autoschema -dtd sample-data.xml

DESCRIPTION

       Takes a stag compatible file (xml, sxpr, itext), or a file in any format plus a parser, and writes out the implicit underlying stag-schema

       stag-schema should look relatively self-explanatory.

       Here is an example stag-schema, shown in sxpr syntax:

	 (db
	  (person*
	   (name "s"
	   (address+
	    (address_type "s")
	    (street "s")
	    (street2? "s")
	    (city "s")
	    (zip? "s")))))

       The database db contains zero or more persons, each person has a mandatory name and at least one address.

       The cardinality mnemonics are as follows:

       +   1 or more

       ?   0 or one

       *   0 or more

       The default cardinality is 1

ARGUMENTS

       -p|parser FORMAT
	   FORMAT is one of xml, sxpr or itext, or the name of a perl module

	   xml assumed as default

       -dtd
	   exports schema as DTD

       -w|writer FORMAT
	   FORMAT is one of xml, sxpr or itext, or the name of a perl module, OR DTD

	   The default is sxpr

	   note that stag schemas exported as xml will be invalid xml, due to the use of symbols *, +, ? in the node names

LIMITATIONS

       not event based - memory usage becomes exhorbitant on large files; prepare a small sample beforehand

perl v5.10.0							    2008-12-23						       STAG-AUTOSCHEMA(1p)
All times are GMT -4. The time now is 09:31 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy