Sponsored Content
Top Forums Shell Programming and Scripting Help using SED to comment XML elements Post 302322369 by fpmurphy on Wednesday 3rd of June 2009 01:42:03 PM
Old 06-03-2009
Sorry but sed or awk are not appropriate tools for massaging XML data (documents) except for very simple files. Instead you need to transform the document using a XSLT stylesheet processor.

BTW Translation_Type is an element and not an attribute. Assuming that your document is valid and well-formed, here is a stylesheet which will do the transformation that you want.

The only change I made was to add a top-level node called "root" for well-formedness. You should change "root" to the name of your top-level element.

Here is the stylesheet:
Code:
<?xml version="1.0" encoding="UTF8" ?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">

    <xsl:template match="node()">
        <xsl:if test="./Translation_Type != '9'" >
            <xsl:copy-of select="."/>
        </xsl:if>
        <xsl:if test="./Translation_Type = '9'" >
           <xsl:text disable-output-escaping="yes">&lt;!-- </xsl:text>
           <xsl:copy-of select="." />
           <xsl:text disable-output-escaping="yes"> --></xsl:text>
        </xsl:if>
        <xsl:text>&#xa;</xsl:text>
    </xsl:template>

    <xsl:template match="root">
       <xsl:element name="{ name() }" >
           <xsl:text>&#xa;</xsl:text>
           <xsl:apply-templates select="*"/>
       </xsl:element>
    </xsl:template>

</xsl:stylesheet>

Note you may have to change the encoding to suit your data set.

Assuming your document is called test.xml and your stylesheet is called test.xsl, invoking xsltproc test.xsl test.xsl gives the following output:
Code:
<?xml version="1.0"?>
<root>
<analysisMessages.js>
        <Source_Eng_Old/>
        <Source_Eng_New>Time Graph Base Properties - Analyze activities relative to time.</Source_Eng_New>
        <Source_Trans_Old/>
        <Target_Trans_New>Time Graph Base Properties - Analyze activities relative to time.</Target_Trans_New>
        <NumOfKeys>1</NumOfKeys>
        <Translation_Type>1</Translation_Type>
        <ResourceId>timeGraph???common_props_title</ResourceId>
</analysisMessages.js>
<ganttChartMessages.js>
        <Source_Eng_Old/>
        <Source_Eng_New>Show</Source_Eng_New>
        <Source_Trans_Old/>
        <Target_Trans_New>Show</Target_Trans_New>
        <NumOfKeys>1</NumOfKeys>
        <Translation_Type>1</Translation_Type>
        <ResourceId>drawGanttChartButtonCaption</ResourceId>
</ganttChartMessages.js>
<!-- <peMessages.js>
        <Source_Eng_Old/>
        <Source_Eng_New>Rerun the selected job</Source_Eng_New>
        <Source_Trans_Old/>
        <Target_Trans_New>Rerun the selected job</Target_Trans_New>
        <NumOfKeys>1</NumOfKeys>
        <Translation_Type>9</Translation_Type>
        <ResourceId>jobGrid???tooltip???RERUN</ResourceId>
</peMessages.js> -->
</root>

Note there are some question marks in the output elements. That is because I did not bother setting up the correct locale and code-set on my system to suit your sample data.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Read elements of a xml file??????

Hi, What is a good way to read elements of an xml file? i did try xmllint it doesnt provide a function to output values of a tree. In the below example when i specify from Family2 I need the name of the father then the output should be DAVE. Appreciate any help provided in this regards. Many... (6 Replies)
Discussion started by: ahmedwaseem2000
6 Replies

2. Shell Programming and Scripting

get rid of xml comment by grep or sed

Hi, I would like to get rid of all comment in an xml file by grep or sed command: The content seem like this: <!-- ab cd ef gh ij kl --> Anyone can help? Thanks and Regards (3 Replies)
Discussion started by: RonLii
3 Replies

3. Shell Programming and Scripting

Using sed to comment out line in /etc/vfstab

I am running a script remotely to do the following 1. Kill all processes by a user 2. Uninstall certain packages 3. FTP over a new file 4. Kill a ldap process that is not allowing my /devdsk/c0t0d0s7 slice to un-mount 5. Unmount /h 6. comment out the slice in vfstab 7. newfs the... (9 Replies)
Discussion started by: deaconf19
9 Replies

4. Shell Programming and Scripting

Comment a line with SED

I have around 25 hosts and each hosts has 4 instance of jboss and 4 different ip attached to it . I need to make some changes to the startup scripts. Any tips appreciated. I have total of 100 instances which bind to 100 different ip address based on instance name. For example File1 ... (1 Reply)
Discussion started by: gubbu
1 Replies

5. Shell Programming and Scripting

Script to put block comment after finding regex in xml file

hi, i need my bash script to find regex in xml file.. and comment 2 lines before and after the line that contains regex.. can't use # needs to be <!-- at the beginning and --> and the end of the comment. so eg.. first block <filter> <filter-name>MyRegEx</filter-name> ... (11 Replies)
Discussion started by: Poki
11 Replies

6. Shell Programming and Scripting

Parsing XML elements and store them in array

Hi Friends Im so confused with using 'for' loop in ksh. I have a xml like the following: <serviceProvider> <serviceProviderID>1</serviceProviderID> <serviceProviderName>Balesh</serviceProviderName> <serviceFeeAmount>30.00</serviceFeeAmount> </serviceProvider>... (2 Replies)
Discussion started by: balesh
2 Replies

7. 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

8. Shell Programming and Scripting

Extract only required elements from XML.

Hi , I have an XML like this. <Request> <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"> <version>v44</version><messageId>7247308192</messageId><timeToLive>72000000000</timeToLive> </Request>. I want to extract on version and messageId. As in my output... (13 Replies)
Discussion started by: chetan.c
13 Replies

9. AIX

Comment out crontab using sed command

I am trying to comment out the crontab entries using sed. I want to comment it out for a particular environment say '/mypath/scripts/'. Using the full path as pattern, it is working. but using variable it is not working. i have tried double quotes too. but no luck! $ crontab -l ... (3 Replies)
Discussion started by: SKhan
3 Replies

10. UNIX for Beginners Questions & Answers

How can we extract specific elements from XML?

Hi, I have a requirement to extract specific element value dynamically from XML message. Here is the sample message: <File> <List> <main> <dir>doc/store834/archive</dir> <count>5</count> </main> <main> <dir>doc/store834/extract</dir> <count>6</count> </main> <main> ... (3 Replies)
Discussion started by: renukeswar
3 Replies
XSLT_PROCESS(3) 							 1							   XSLT_PROCESS(3)

xslt_process - Perform anXSLTtransformation

SYNOPSIS
mixed xslt_process (resource $xh, string $xmlcontainer, string $xslcontainer, [string $resultcontainer], [array $arguments], [array $parameters]) DESCRIPTION
The xslt_process(3) function is the crux of the XSLT extension. It allows you to perform an XSLT transformation using almost any type of input source - the containers. This is accomplished through the use of argument buffers -- a concept taken from the SablotronXSLT processor (currently the only XSLT processor this extension supports). The input containers default to a filename 'containing' the document to be processed. PARAMETERS
o $ xh -The XSLT processor link identifier, created with xslt_create(3). o $xmlcontainer - Path to XML file or placeholder for the XML argument. o $xslcontainer - Path to XSL file or placeholder for the XML argument. o $resultcontainer - The result container defaults to a filename for the transformed document. If the result container is not specified - i.e. NULL - than the result is returned. o $arguments - Instead of files as the XML and XSLT arguments to the xslt_process(3) function, you can specify "argument place holders" which are then substituted by values given in the $arguments array. o $parameters - An array for any top-level parameters that will be passed to the XSLT document. These parameters can then be accessed within your XSL files using the <xsl:param name="parameter_name"> instruction. The parameters must be UTF-8 encoded and their values will be interpreted as strings by the Sablotron processor. In other words - you cannot pass node-sets as parameters to the XSLT docu- ment. Containers can also be set via the $arguments array (see below). RETURN VALUES
Returns TRUE on success or FALSE on failure. If the result container is not specified - i.e. NULL - than the result is returned. CHANGELOG
+--------+---------------------------------------------------+ |Version | | | | | | | Description | | | | +--------+---------------------------------------------------+ | 4.0.6 | | | | | | | This function no longer takes XML strings in | | | $xmlcontainer or $xslcontainer. Passing a string | | | containing XML to either of these parameters will | | | result in a segmentation fault in Sablotron ver- | | | sions up to and including version 0.95. | | | | +--------+---------------------------------------------------+ EXAMPLES
The simplest type of transformation with the xslt_process(3) function is the transformation of an XML file with an XSLT file, placing the result in a third file containing the new XML (or HTML) document. Doing this with Sablotron is really quite easy... Example #1 Using the xslt_process(3) to transform an XML file and a XSL file to a new XML file <?php // Allocate a new XSLT processor $xh = xslt_create(); // Process the document if (xslt_process($xh, 'sample.xml', 'sample.xsl', 'result.xml')) { echo "SUCCESS, sample.xml was transformed by sample.xsl into result.xml"; echo ", result.xml has the following contents <br /> "; echo "<pre> "; readfile('result.xml'); echo "</pre> "; } else { echo "Sorry, sample.xml could not be transformed by sample.xsl into"; echo " result.xml the reason is that " . xslt_error($xh) . " and the "; echo "error code is " . xslt_errno($xh); } xslt_free($xh); ?> While this functionality is great, many times, especially in a web environment, you want to be able to print out your results directly. Therefore, if you omit the third argument to the xslt_process(3) function (or provide a NULL value for the argument), it will automatically return the value of the XSLT transformation, instead of writing it to a file... Example #2 Using the xslt_process(3) to transform an XML file and a XSL file to a variable containing the resulting XML data <?php // Allocate a new XSLT processor $xh = xslt_create(); // Process the document, returning the result into the $result variable $result = xslt_process($xh, 'sample.xml', 'sample.xsl'); if ($result) { echo "SUCCESS, sample.xml was transformed by sample.xsl into the $result"; echo " variable, the $result variable has the following contents <br /> "; echo "<pre> "; echo $result; echo "</pre> "; } else { echo "Sorry, sample.xml could not be transformed by sample.xsl into"; echo " the $result variable the reason is that " . xslt_error($xh); echo " and the error code is " . xslt_errno($xh); } xslt_free($xh); ?> The above two cases are the two simplest cases there are when it comes to XSLT transformation and I'd dare say that they are the most com- mon cases, however, sometimes you get your XML and XSLT code from external sources, such as a database or a socket. In these cases you'll have the XML and/or XSLT data in a variable -- and in production applications the overhead of dumping these to file may be too much. This is where XSLT's "argument" syntax, comes to the rescue. Instead of files as the XML and XSLT arguments to the xslt_process(3) function, you can specify "argument place holders" which are then substituted by values given in the arguments array (5th parameter to the xslt_process(3) function). The following is an example of processing XML and XSLT into a result variable without the use of files at all. Example #3 Using the xslt_process(3) to transform a variable containing XML data and a variable containing XSL data into a variable containing the resulting XML data <?php // $xml and $xsl contain the XML and XSL data $arguments = array( '/_xml' => $xml, '/_xsl' => $xsl ); // Allocate a new XSLT processor $xh = xslt_create(); // Process the document $result = xslt_process($xh, 'arg:/_xml', 'arg:/_xsl', NULL, $arguments); if ($result) { echo "SUCCESS, sample.xml was transformed by sample.xsl into the $result"; echo " variable, the $result variable has the following contents <br /> "; echo "<pre> "; echo $result; echo "</pre> "; } else { echo "Sorry, sample.xml could not be transformed by sample.xsl into"; echo " the $result variable the reason is that " . xslt_error($xh); echo " and the error code is " . xslt_errno($xh); } xslt_free($xh); ?> Example #4 Passing PHP variables to XSL files <?php // XML string $xml = '<?xml version="1.0"?> <para> change me </para>'; // XSL string $xsl = ' <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="html" encoding="ISO-8859-1" indent="no" omit-xml-declaration="yes" media-type="text/html"/> <xsl:param name="myvar"/> <xsl:param name="mynode"/> <xsl:template match="/"> My PHP variable : <xsl:value-of select="$myvar"/><br /> My node set : <xsl:value-of select="$mynode"/> </xsl:template> </xsl:stylesheet>'; $xh = xslt_create(); // the second parameter will be interpreted as a string $parameters = array ( 'myvar' => 'test', 'mynode' => '<foo>bar</foo>' ); $arguments = array ( '/_xml' => $xml, '/_xsl' => $xsl ); echo xslt_process($xh, 'arg:/_xml', 'arg:/_xsl', NULL, $arguments, $parameters); ?> The above example will output: My PHP variable : test<br> My node set : &lt;foo&gt;bar&lt;/foo&gt; NOTES
Note Please note that file:// is needed in front of the path when using Windows. PHP Documentation Group XSLT_PROCESS(3)
All times are GMT -4. The time now is 10:14 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy