How to trim the space in the XML string excluding the XML namespace header in C#?

Question

1.00/5 (1 vote)

See more:

I want to trim the space in the xml string excluding the xml namespace header in c#. My xml string is as below. I want to trim the xml node values alone excluding the namespace header (getInstallmentHistoryReply xmlns:NS1="urn:esbbank.com/gbo/xml/schemas/v1_0/")

XML

<getInstallmentHistoryReply xmlns:NS1="urn:esbbank.com/gbo/xml/schemas/v1_0/">
	<eAI_HEADER>
		<serviceName>GET.FINANCE.DETAIL</serviceName>
		<serviceType>SYNC</serviceType>
		<serviceVersion>1.0</serviceVersion>
		<client>ADIB</client>
		<clientChannel>DDS</clientChannel>
		<msgChannel>HTTP</msgChannel>
		<requestorLanguage>E</requestorLanguage>
		<securityInfo>
			<authentication>
				<UserId>DDS</UserId>
				<Password>XXXXXXXXXX</Password>
			</authentication>
		</securityInfo>
		<returnCode>0000</returnCode>
	</eAI_HEADER>
</getInstallmentHistoryReply>

What I have tried:

My code is as below

string ResponseXML_Updated = ResponseXML.Replace("NS1:getInstallmentHistoryReply", "getInstallmentHistoryReply");
            
            string ResponseXML_Trimmed = System.Text.RegularExpressions.Regex.Replace(ResponseXML_Updated, @"(([^\s]+)\s+)", "$2"); 
           
            
            System.Xml.XmlDocument xd1 = new System.Xml.XmlDocument();
            xd1.LoadXml(ResponseXML_Trimmed);

Posted 12-Mar-24 20:39pm

Member 7513082

Updated 13-Mar-24 6:51am

PIEBALDconsult

v4

Add a Solution

Comments

Richard Deeming 18-Mar-24 9:25am

Why? The XmlDocument doesn't care about whitespace between nodes. And if you want to trim space from node values, then it would be far better to load the XML and then process the node values using the XmlDocument.

Trying to use regular expressions to manipulate XML is only going to cause headaches!

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Accepted Answer · 2024-03-12T21:21:00

Two things - firstly, you need to remove the <pre> from your xml or it will not process before you even start to "trim" it.

Secondly you cannot blindly remove all spaces: if you look at the string you generated:

XML

<getInstallmentHistoryReplyxmlns:NS1="urn:esbbank.com/gbo/xml/schemas/v1_0/"><eAI_HEADER><serviceName>GET.FINANCE.DETAIL</serviceName>...

you can see that it is not valid XML: it needs a space between the getInstallmentHistoryReply tag and the xmlns: attribute or the whole looks like a longer attribute name with no proper tag preceding it.
I would suggest that you change your regex to only remove whitespace following a > tag ending marker