DELETING TAGS ON XML DOCUMENT

(0) Share

Report

Posted on by Community Member

Hi All,

I have this XML document that is too large. There are certain tags that I would like to remove, the problem is I tried going through the document line by line, but it takes up mot of my time. If not, I might miss some of the tags I want to delete.
Please can someone assist me with this step by step

Thank you in advance

Musa

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

David Jennaway 14,065 on at

Like (0)

Report

There are various tools that you can use to edit xml documents. If you have a SQL Server, then you can use the SQLXML functions to delete tags.

See http://www.sqlmusings.com/2009/04/12/sqlxml-how-to-work-with-xml-elements-or-nodes-in-sql-server/ for some examples (note that what you refer to as 'tags' are 'elements')

Was this reply helpful? Yes No
Harshil Shah 294 on at

Like (0)

Report
Hello Musa Ntuli,

One way of doing this will be create a C# utility and read XML tag by tag and whatever tags which you required write them in new XML file.

Other way will be Format your XML code & paste it in Notepad++ or any good Text editor. Using "Find all" identify all occurrence of XML tag and remove/Replace them.

Regards,

Harshil Shah

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you David for the advice.

Noted on the element issue, thank you

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have been trying the second option and have watched some videos, they show pasting a Regular Expression, but they don't show how they go about getting the regular expression.

I am new into this Dynamics 365 Customer Engagement, I am still trying to find my feet.

Thanks.

Was this reply helpful? Yes No