SSDN - How do i delete the node from xml based on the value of a tag

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

Amrit Singh

Subject: How do i delete the node from xml based on the value of a tag
Author: Amrit Singh
Date: 06 Apr 2015 02:09 AM

Hi,

if the character inside the addr1,addr2,addr3 exceeds 31 character then i would like to delete the tag .

For example :In the following tree ,If you find that under <billaddress> and <shipaddress> addr3 is exceeding 31 characters .So i want to delete the entire shipping address .

<InvoiceAddRq requestID="959">
<InvoiceAdd defMacro="TxnID:1162">
<CustomerRef>
<FullName>Mary Traudt</FullName>
</CustomerRef>
<ARAccountRef>
<FullName>Accounts Receivable</FullName>
</ARAccountRef>
<TxnDate>2014-07-01</TxnDate>
<RefNumber>1212</RefNumber>
<BillAddress>
<Addr1>Mary Traudt</Addr1>
<Addr2>1390 Caxambas Court</Addr2>
<Addr3>Marco Island, FL 34145
Collier</Addr3>
</BillAddress>
<ShipAddress>
<Addr1>Mary Traudt</Addr1>
<Addr2>1390 Caxambas Court</Addr2>
<Addr3>Marco Island, FL 34145
Collier</Addr3>
</ShipAddress>
<TermsRef>
<FullName>Net 15</FullName>
</TermsRef>
<DueDate>2014-07-16</DueDate>
<CustomerMsgRef>
<FullName>NOTE- All invoices over $500 paid by CHECK-
PO Box 1401, Marco Island, FL 34146

Thank you for yo</FullName>
</CustomerMsgRef>
<IsToBePrinted>false</IsToBePrinted>
<InvoiceLineAdd>
<ItemRef>
<FullName>Cleaning Services</FullName>
</ItemRef>
<Desc>Cleaning Services</Desc>
<Quantity>1</Quantity>
<Rate>90</Rate>
<OverrideItemAccountRef>
<FullName>Services</FullName>
</OverrideItemAccountRef>
</InvoiceLineAdd>
</InvoiceAdd>
</InvoiceAddRq>
I have attached an xml sample file .

export_company.xml

Ivan Pedruzzi

Subject: How do i delete the node from xml based on the value of a tag
Author: Ivan Pedruzzi
Date: 07 Apr 2015 07:43 PM

These boards are part of the Stylus Studio Developer Network. They are a service to users of Stylus Studio only.

You need to design an identity transformation which matches only what you need to check/remove and let through the rest of the document.

Ivan Pedruzzi
Stylus Studio Team

Topic Page 1 2 3 4 5 6 7 8 9

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.