Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Pulling data from xml
Top Forums Shell Programming and Scripting Pulling data from xml Post 302788863 by ssideel on Tuesday 2nd of April 2013 03:51:02 PM
Old 04-02-2013
Linux 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
 

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 Replies)
Discussion started by: MizzGail
2 Replies

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... (1 Reply)
Discussion started by: khuilman
1 Replies

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... (1 Reply)
Discussion started by: codenjanod
1 Replies

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... (4 Replies)
Discussion started by: LuffyDMonkey
4 Replies

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 Replies)
Discussion started by: Mikey
6 Replies

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... (5 Replies)
Discussion started by: sudo
5 Replies

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... (4 Replies)
Discussion started by: sudo
4 Replies

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}'... (6 Replies)
Discussion started by: SkySmart
6 Replies

LEARN ABOUT DEBIAN

tv_sort

TV_SORT(1p)						User Contributed Perl Documentation					       TV_SORT(1p)

NAME

       tv_sort - Sort XMLTV listings files by date, and add stop times.

SYNOPSIS

       tv_sort [--help] [--by-channel] [--output FILE] [FILE...]

DESCRIPTION

       Read XMLTV data and write out the same data sorted in date order.  Where stop times of programmes are missing, guess them from the start
       time of the next programme on the same channel. For the last programme of a channel, no stop time can be added.

       Tv_sort also performs some sanity checks such as making sure no two programmes on the same channel overlap.

       --output FILE write to FILE rather than standard output

       --by-channel sort first by channel id, then by date within each
		       channel.

       --duplicate-error If the input contains the same programme more than once,
			    consider this as an error. Default is to silently
			    ignore duplicate entries.

       The time sorting is by start time, then by stop time.  Without --by-channel, if start times and stop times are equal then two programmes
       are sorted by internal channel id.  With --by-channel, channel id is compared first and then times.

       You can think of tv_sort as converting XMLTV data into a canonical form, useful for diffing two files.

EXAMPLES

       At a typical Unix shell or Windows command prompt:

       tv_sort <in.xml >out.xml
       tv_sort in.xml --output out.xml

       These are different ways of saying the same thing.

AUTHOR

       Ed Avis, ed@membled.com

perl v5.14.2							    2006-03-02							       TV_SORT(1p)
All times are GMT -4. The time now is 11:57 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy