Extracting a part of XML File Post: 302256588

Sponsored Content

Top Forums Shell Programming and Scripting Extracting a part of XML File Post 302256588 by shridhard on Monday 10th of November 2008 07:21:07 AM

11-10-2008

Registered User

Extracting a part of XML File

Hi Guys,

I have a very large XML feed (2.7 MB) which crashes the server at the time of parsing. Now to reduce the load on the server I have a cron job running every 5 min.'s. This job will get the file from the feed host and keep it in the local machine.

This does not solve the problem as the file still gets loaded in the server. The file looks something like this:

<?xml version="1.0" standalone="no"?>
<IRXML CorpMasterID="">
<NewsReleases PubDate="20081104" PubTime="16:48:03">
<NewsCategory Category="">
<NewsRelease ReleaseID="" DLU="20081104 16:47:00" ArchiveStatus="Current"
RNSSource="">
<Title></Title>
<ExternalURL/>
<Date Date="20081104" Time="16:33:00">11/4/2008 4:33:00 PM</Date>
<ContentNetworkingLinks/>
<Categories>
<Category></Category>
</Categories>
</NewsRelease>
<NewsRelease ReleaseID="" DLU="20081104 09:19:00" ArchiveStatus="Current"
RNSSource="">
<Title></Title>
<ExternalURL/>
<Date Date="20081104" Time="09:01:00">11/4/2008 9:01:00 AM</Date>
<ContentNetworkingLinks/>
<Categories>
<Category></Category>
</Categories>
</NewsRelease>

I want to write a shell script which will extract only the part starting from
<NewsRelease> till </NewsRelease>
Something like:

<NewsRelease ReleaseID="" DLU="20081104 09:19:00" ArchiveStatus="Current"
RNSSource="">
<Title></Title>
<ExternalURL/>
<Date Date="20081104" Time="09:01:00">11/4/2008 9:01:00 AM</Date>
<ContentNetworkingLinks/>
<Categories>
<Category></Category>
</Categories>
</NewsRelease>

Also there is one more problem, in unix when the file is downloaded there are no return carriage, so the complete file appears to be in one line Smilie

.

Any help would be appreciated. Thanks,
Shridhar

shridhard

View Public Profile for shridhard

Find all posts by shridhard

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

extracting XML file using sed

Hello folks I want to extract data between certain tag in XML file using 'sed' <xml> ......... .......... <one>XXXXXXXXXXXXXXXXXXXX</one> ...... Anyone ?Thank you

2. Shell Programming and Scripting

Extracting Data from xml file

Hi ppl out there... Can anyone help me with the shell script to extract data from an xml file. My xml file looks like : - <servlet> <servlet-name>FrontServlet</servlet-name> <display-name>FrontServlet</display-name> ...

3. Shell Programming and Scripting

extracting part of a text file

Hi guys So I have a very large log file where each event is logged along with the time that it occurred. So for e.g. The contents of the file look like: ... 12:00:07 event 0 happened. 12:01:01 event 1 happened. 12:01:05 event 2 happened. 12:01:30 event 3 happened. 12:02:01 event 4...

4. UNIX for Dummies Questions & Answers

Extracting values from an XML file

Hello People, I have an xml file from which I need to extract the values of the parameters using UNIX shell commands. Ex : Input is like : <Name>Roger</Name> or <Address>MI</Address> I need the output as just : Roger or MI with the tags removed. Please help.

5. UNIX for Dummies Questions & Answers

Extracting data from an xml file

Hello, Please can someone assist. I have the following xml file: <?xml version="1.0" encoding="utf-8" ?> - <PUTTRIGGER xmlns:xsd="http://www.test.org/2001/XMLSchema" xmlns:xsi="http://www.test.org/2001/XMLSchema-instance" APPLICATIONNUMBER="0501160" ACCOUNTNAME="Mrs S Test"...

6. Shell Programming and Scripting

Need help in extracting data from xml file

Hello, This is my first post in here, so excuse me if I sound too noob here! I need to extract the path "/apps/mp/installedApps/V61/HRO/hrms_01698_A_qa.ear" from the below xml extract. The path will always appear with the key "binariesURL" <deployedObject...

7. Shell Programming and Scripting

Extracting content from xml file

Hello All, Hope you are doing well!!!!! I have a small code in the below format in xml file: <UML:ModelElement.taggedValue> <UML:TaggedValue tag="documentation" value="This sequence

HLD_EA_0001X
HLD_DOORS_002X"/> <UML:TaggedValue tag="documentation" value="This...

8. Shell Programming and Scripting

Reading XML file and extracting value

Dear All, I am reading one XML file to extract value from the particular tag:- Sample xml is below:- <KeyValuePairs> <Key>TestString</Key> <Value>Test12_Pollings</Value> </KeyValuePairs> I want to read the value for the KEY tag and there will be multiple key tags :- awk...

9. Shell Programming and Scripting

Extracting the tag name from an xml file

Hi, My requirement is something like this, I have a xml file that contains some tags and nested tags, <n:tag_name1> <n:sub_tag1>val1</n:sub_tag1> <n:sub_tag2>val2</n:sub_tag2> </n:tag_name1> <n:tag_name2> <n:sub_tag1>value</n:sub_tag1> ...

10. Shell Programming and Scripting

Need Help in extracting data from XML File

Hi All My input file is an XML and it has some tags and data rows at end. Starting of data rows is <rs:data> and ending of data rows is </rs:data>. Within sample data rows (2 rows) shown below, I want to extract data value after equal to sign (until space or "/" sign). So if XML data...

LEARN ABOUT PLAN9

cron

CRON(8) 						      System Manager's Manual							   CRON(8)

NAME

       cron - clock daemon

SYNOPSIS

       auth/cron [-c]

DESCRIPTION

       Cron executes commands at specified dates and times according to instructions in the files /cron/user/cron.  It runs only on an authentica-
       tion server.  Option -c causes cron to create /cron/user and /cron/user/cron for the current user; it can be run from any Plan 9 machine.

       Blank lines and lines beginning with # in these files are ignored.  Entries are lines with fields

	      minute hour day month weekday host command

       Command is a string, which may contain spaces, that is passed to an rc(1) running on host for execution.  The first five fields are integer
       patterns for

	      minute	     0-59

	      hour	     0-23

	      day of month   1-31

	      month of year  1-12

	      day of week    0-6; 0=Sunday

       The syntax for these patterns is

	      time  : '*'
		    | range
	      range : number
		    | number '-' number
		    | range ',' range

       Each number must be in the appropriate range.  Hyphens specify inclusive ranges of valid times; commas specify lists of valid time ranges.

       To run the job, cron calls host and authenticates remote execution, equivalent to running rx host command (see con(1)).	The user's profile
       is run with $service set to rx.

       Cron is not a reliable service.	It skips commands if it cannot reach host within two minutes, or if the cron daemon is not running at  the
       appropriate time.

EXAMPLES

       Here is the job that mails system news.

	      % cat /cron/upas/cron
	      # send system news
	      15 8-17, 21 ***	  helix     /mail/lib/mailnews
	      %

SOURCE

       /sys/src/cmd/auth/cron.c

SEE ALSO

       con(1), rc(1)

																	   CRON(8)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

extracting XML file using sed

Discussion started by: pujansrt

2. Shell Programming and Scripting

Extracting Data from xml file

Discussion started by: nishana

3. Shell Programming and Scripting

extracting part of a text file

Discussion started by: alinaqvi90

4. UNIX for Dummies Questions & Answers

Extracting values from an XML file

Discussion started by: sushant172