Replace < sign with > and & with & in XML file at particular node or position

Question

0.00/5 (No votes)

See more:

Hi All,

I have a XML file which have a node called Section as below. As XML treats & and < sign as an invalid characters. So i want to replace < sign with 'AmpersandLTsemicolon ('<')' and & with 'AmpersandAMPsemicolon' in Section Node as shown below.

I want 'AmpersandLTsemicolon' should be replaced only in section node.

below is my XML markup :-

C#

<?xml version="1.0" encoding="utf-8"?>
    <webpage xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Tabs>
      <Tab Name="Description">
         <Section Name="Description < &">
            <Field Type="Hidden" Property="EmployeeID" Desc="Employee ID" ColWidth="20"/>
         </Section>
     </Tab>
    </Tabs>
</Webpage>

New XML should be :-

C#

<?xml version="1.0" encoding="utf-8"?>
    <webpage xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Tabs>
      <Tab Name="Description">
         <Section Name="Description < &"> like AmpersandLTSemicolon and AmpersandAMPSemicolon
            <Field Type="Hidden" Property="EmployeeID" Desc="Employee ID" ColWidth="20"/>
         </Section>
     </Tab>
    </Tabs>
    </Webpage>

Please help me on this.

What I have tried:

I tried to replace < with AmpersandLTSemicolon using indexOF method, then it replaces AmpersandLTSemicolon in all start tags of XML file.

Posted 20-Feb-18 22:28pm

Member 11052432

Add a Solution

Comments

Suvendu Shekhar Giri 21-Feb-18 4:49am

Please show the code you already have tried.

Member 11052432 21-Feb-18 5:02am

if (xmlString.indexOf("&") >= 0 || xmlString.indexOf("<") >= 0)
{
xmlString = xmlString.replace(/\&/g, '&').replace(/</g, '<');
} -- like AmpersandLTsemicolon and AmpersandAMPSemicolon... AmpersandLTsemicolon is not showing in code project as it is denied like it should be
replace(/</g, 'AmpersandLTSemicolon in HTML form').

Kindly solve this issue.

A_Griffin 21-Feb-18 5:14am

What's wrong with
Replace("<Section Name=""Description < &"">", "<Section Name=""Description [whatever you want]"">")

Member 11052432 21-Feb-18 5:32am

< sign does not work in XML. When is use $.parseXML method, then it shows invalid XML. That is the reason i need to replace less than sign with AmpersandLTSemicolon to parse it a valid XML.

How to find out Section node or name and find less than sign inside it and replace only in Section node.

A_Griffin 21-Feb-18 5:40am

Yes, I know... so replace it as I suggested.

Member 11052432 21-Feb-18 6:13am

Hi A_Griffin, where is your solution.
Please provide me solution.
Thanks!!!!!

A_Griffin 21-Feb-18 6:22am

? It's right above, in the first thing I posted.

Member 11052432 21-Feb-18 6:23am

Sorry i did not find your solution, can you please paste it again.

A_Griffin 21-Feb-18 6:53am

Replace("<Section Name=""Description < &"">", "<Section Name=""Description [whatever you want]"">")

A_Griffin 21-Feb-18 5:43am

Or do you have any options to change the JSON at source? It's a rather silly value for an attribute in a JSON node.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Replace < sign with > and & with & in XML file at particular node or position

Add your solution here

Preview 0

Replace < sign with &gt; and & with &amp; in XML file at particular node or position

Add your solution here

Preview 0

Existing Members

...or Join us

Replace < sign with > and & with & in XML file at particular node or position