Pulling data from xml Post: 302788863

Sponsored Content

Top Forums Shell Programming and Scripting Pulling data from xml Post 302788863 by ssideel on Tuesday 2nd of April 2013 03:51:02 PM

04-02-2013

Registered User

Pulling data from xml

Hi there, Please could anyone help with this.
I have an xml file that contains repeating values eg

Code:

<Rule name> AAAAA
<Action> BBBBB
</Action>
<Data> CCCCC
</Data>
<Type> DDDDD
</Type>
</Rule name>

<Rule name> A1A1A1A1
<Action> B1B1B1B1
</Action>
<Data> C1C1C1C
</Data>
<Type> D1D1D1D
</Type>
<Rule> Do this 
</Rule>
</Rule name>

And this repeats throughout the xml many times but the values between <Rule name> and </Rule name> varies there could be more or less xml values but I want all data between <Rule name> and </Rule name>. Rule name repeates many times throughout the file and I would like to pull all if poss
I have been using Sed but not with much luck, Any help would be much appreciated
can use sed, Awk, Perl or if you think better something else
many thanks Regards

Last edited by Scrutinizer; 04-02-2013 at 05:20 PM.. Reason: code tags

ssideel

View Public Profile for ssideel

Find all posts by ssideel

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Pulling data and following lines from file

I saw a few posts close to what i want to do, but they didn't look like they would work exactly.. or I need to think out of the box on this. I have a file that I keep server stats in for my own performance analysis. this file has the output from many commands in it (uptime, vmstats, ps, swap...

2. Shell Programming and Scripting

Pulling data from a standard comment block - perl

OK so I've inherited a set of scripts that do some work on a database. They do all have a standard comment block at the beginning that has good information on the script. I would like to generate a quick web page report that lists the script name and the description lines (for now it may be...

3. Shell Programming and Scripting

SFTP to server, pulling data and removing the data

Hi all, I have the following script, but are not too sure about the syntax to complete the script. In essence, the script must connect to a SFTP server at a client site with username and password located in a file on my server. Then change to the appropriate directory. Pull the data to the...

4. Shell Programming and Scripting

Help with pulling / filtering data from a .csv

Good day Gurus, I have a csv file that contains an inventory of active servers. This csv file contains a well over a hundred systems (IBM, SUN, HP). It also contains those systems details. See below for an example hostA,invver,1.02,20100430 hostA,date,08/30/2010,06:18 hostA,use,"Unknown...

5. Shell Programming and Scripting

Pulling data by GPS coordinates from text file

Hi there, I'm having a problem trying to extract data from within a text file. I'm trying to extract this manually for a lack of better words. I need any items that fall within latitude 36.5 to 39.5 and long -75.3 to -83.9 I have been doing this using cat neta.txt | grep '!38' and working...

6. Shell Programming and Scripting

BASH- Need help pulling data from .emlx

Hello, fellow computer junkies. First time poster! My boss wrote an application (Mavericks 10.9, Mountain Lion 10.8) that checks a user's security settings. The user runs the application, then it spits out an email that is sent back to our inbox showing the results. On our end, we have a mail rule...

7. Shell Programming and Scripting

Pulling Data, Then Moving to the Next File

I'm scanning a list of emails- I need to pull 2 pieces of data, then move to the next file: Sender's Email Address Email Date I need these to be outputted into a single column- separated by a ",". Like this: Email1's Address, Email1's Date Stamp Email2's Address, Email2's Date Stamp...

8. Shell Programming and Scripting

Pulling information from a data file by date

awk -v now="$(date +%s)" -v tDiff="${USERMINUTES}" ' BEGIN { FS="=" if (!now) now=systime() if (!tDiff) tDiff=60*60 p=1 } /{/ {rec=$0;p=1;next} /}/ && rec && p {print rec ORS $0;next} $1=="entry_time" { if (now-$2>tDiff)p=0 } {rec=rec ORS $0}'...

LEARN ABOUT DEBIAN

stag-flatten

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

NAME

       stag-flatten - turns stag data into a flat table

SYNOPSIS

	 stag-flatten -c name -c person/name dept MyFile.xml

DESCRIPTION

       reads in a file in a stag format, and 'flattens' it to a tab-delimited table format. given this data:

	 (company
	  (dept
	   (name "special-operations")
	   (person
	    (name "james-bond"))
	   (person
	    (name "fred"))))

       the above command will return a two column table

	 special-operations	 james-bond
	 special-operations	 fred

       If there are multiple values for the columns within the node, then the cartesian product will be calculated

USAGE

	 stag-flatten [-p PARSER] [-c COLS] [-c COLS] NODE <file>

ARGUMENTS

       -p|parser FORMAT
	   FORMAT is one of xml, sxpr or itext

	   xml assumed as default

       -c|column COL1,COL2,COL3,..
	   the name of the columns/elements to write out

	   this can be specified either with multiple -c arguments, or with a comma-seperated (no spaces) list of column (terminal node) names
	   after a single -c

       -n|nest
	   if set, then the output will be a compress repeating values into the same row; each cell in the table will be enclosed by {}, and will
	   contain a comma-delimited set of values

SEE ALSO

       Data::Stag

perl v5.10.0							    2008-12-23							  STAG-FLATTEN(1p)