Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Replacing the last record in xml with different tags
Top Forums Shell Programming and Scripting Replacing the last record in xml with different tags Post 302435866 by aigles on Thursday 8th of July 2010 11:00:58 AM
Old 07-08-2010
A solution with AWK :
Code:
awk '

function print_RevenueAmounts() {
   if ( count ) {
      for (i=1; i<=count; i++)
         print Ra[i];
   }
   count = 0;
}

/^[[:space:]]*<RevenueAmounts/ {
   print_RevenueAmounts();
   elementTotal++;
}

/^[[:space:]]*<RevenueAmounts/,/^[[:space:]]*<\/RevenueAmounts/ {
   Ra[++count] = $0;
   next;
}

/^[[:space:]]*<\/Report>/ {
   print "<ReportTrailer>";
   sub(/element="[0-9]*"/, "element_total=\"" elementTotal-1 "\"", Ra[1]);
   for (i=1; i<=count; i++) {
      if ( Ra[i] !~ /<\/?(Credit|Debit)/ )
         gsub(/<\/?[[:alpha:]_]+/,"&_total", Ra[i]);
   }
   print_RevenueAmounts()
   print "</ReportTrailer>";
   print;
   next;
}

1

' file.xml

Jean-Pierre.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

replacing string in an XML file

Hi all, I need to replace string in XML file..XML file like <dependency> <groupId>fr.orange.portail.ear</groupId> <artifactId>_AdminServicesEAR</artifactId> <version>1.0.0-20080521.085352-1</version> <type>ear</type> </dependency> <dependency> ... (2 Replies)
Discussion started by: subin_bala
2 Replies

2. UNIX for Advanced & Expert Users

How to read an Xml record contained in a file--urgent

Hi I have an xml file which has multiple xml records.. I don't know how to read those records and pipe them to another shell command the file is like <abc>z<def>y<ghi>x........</ghi></def></abc> (1st record) <jkl>z<mno>y<pqr>x........</pqr></mno></jkl> (2nd record) Each record end... (4 Replies)
Discussion started by: aixjadoo
4 Replies

3. Shell Programming and Scripting

Replacing number between xml tags with ksh shell script

Hallo, im basically a complete noob on shell scripting and im trying to replace or rather add 1 to a number between xml tags. The xml basically has a tag somewhere that looks like this: <tag>12345678901234</tag> Now i want to replace the number between the tags. And i want the file to... (6 Replies)
Discussion started by: Demoric
6 Replies

4. Shell Programming and Scripting

Replacing part of XML code inside comment tags

Hello! I'd like to modify custom values in a XML config file between comment tags using bash script. <feature> <keyboardshortcut>C-m</keyboardshortcut> <option1>disabled</option2> <option2>enabled</option2> </feature> <!-- bash script features START --> <feature> ... (2 Replies)
Discussion started by: prism1
2 Replies

5. Shell Programming and Scripting

Reading XML and replacing a string

Hi All, My thanks in advance for you guys reading this and for any posts. I'm having 100 XML files, I need script which replace a specific string. It must be incrementing in 100 xml files.. Sample XML files: <hwIPHostName type="attrib">DEMO1</hwIPHostName> I need Demo1 to be... (4 Replies)
Discussion started by: karty2129
4 Replies

6. Shell Programming and Scripting

How to add the multiple lines of xml tags before a particular xml tag in a file

Hi All, I'm stuck with adding multiple lines(irrespective of line number) to a file before a particular xml tag. Please help me. <A>testing_Location</A> <value>LA</value> <zone>US</zone> <B>Region</B> <value>Russia</value> <zone>Washington</zone> <C>Country</C>... (0 Replies)
Discussion started by: mjavalkar
0 Replies

7. Shell Programming and Scripting

Shell Command to compare two xml lines while ignoring xml tags

I've got two different files and want to compare them. File 1 : HTML Code: <response ticketId="944" type="getQueryResults"><status>COMPLETE</status><description>Query results fetched successfully</description><recordSet totalCount="1" type="sms_records"><record... (1 Reply)
Discussion started by: Shaishav Shah
1 Replies

8. Shell Programming and Scripting

Replacing a value in all xml's

Hi Folks, Could you please advise what will be the unix command to replace the character in all xml's under a particular directory for example let say I rite now at the following below location $ cd /opt/apr/rt/conf now under conf there are so many xml's and in those xml's i want to... (2 Replies)
Discussion started by: punpun66
2 Replies

9. Shell Programming and Scripting

Extract timestamp from first record in xml file and it checks if not it will replace first record

I have test.xml <emp><id>101</id><name>AAA</name><date>06/06/14 1811</date></emp> <Join><id>101</id><city>london</city><date>06/06/14 2011</date></join> <Join><id>101</id><city>new york</city><date>06/06/14 1811</date></join> <Join><id>101</id><city>sydney</city><date>06/06/14... (2 Replies)
Discussion started by: vsraju
2 Replies

10. Shell Programming and Scripting

Replacing tab value in xml file

Hi I am working on xml file. I have to make sure below lines containing values within quotes are replaced by some character like "-". Below are different lines in xml file. Pattern 1: <Connector port=.... ..... keystoremyPass="xxx" /> Pattern 2: myword="xxxxx" ... (11 Replies)
Discussion started by: krsnadasa
11 Replies

LEARN ABOUT DEBIAN

docbook2gjots

DOCBOOK2GJOTS(1)					      General Commands Manual						  DOCBOOK2GJOTS(1)

NAME

       docbook2gjots - Convert a DOCBOOK file to gjots format (on stdout)

SYNOPSIS

       docbook2gjots [ DOCBOOK-file ]

DESCRIPTION

       docbook2gjots converts a DOCBOOK XML file into gjots format.

       docbook2gjots uses gawk(1) to perform the conversion.

       <preface>,  <chapter>,  <section>,  <sect1>,  <sect2>,  <sect3> and <sect4> tags are used to define NewEntry and NewFolder boundaries. They
       should definitely have <title> tags.

       This is a quick and dirty hack using gawk(1) and does no formal checking of XML or SGML syntax nor does it  validate  against  the  DOCBOOK
       DTD. Consequently, if the syntax of the file is broken the conversion will probably fail.

       It is intended that a round-trip can be made so that gjots(1) can be used as a tool at all stages of DOCBOOK production - mainly as an out-
       line processor to help the author organise and order the work.  A document may well start its life in gjots(1) as the initial thoughts  are
       marshalled.  As	the  document  forms  up,  it can be converted to DOCBOOK with the following command which automatically adds tags such as
       <?xml...>, <para> etc:

	      gjots2docbook -b file.gjots >file.xml
	      docbook2pdf file.xml

       Or, starting with an existing DOCBOOK file:

	      docbook2gjots file.xml >file.gjots

       In the latter case, the document will already have a lot of DOCBOOK tags so to convert back to docbook, add the -e and -p options:

	      gjots2docbook -b -p -e file.gjots >file.xml
	      docbook2pdf file.xml

AUTHOR

       Written by Bob Hepple <bhepple@freeshell.org>

       http://bhepple.freeshell.org/gjots

COPYRIGHT

       Copyright (c) 2002 Robert Hepple
       This  is  free software; see the source for copying conditions.	There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR  A  PAR-
       TICULAR PURPOSE.

SEE ALSO

       gjots(1), gjots2html(1), gjots2docbook(1)

																  DOCBOOK2GJOTS(1)
All times are GMT -4. The time now is 10:09 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy