Removing/Replacing white spaces in Xml Tag stored in a string using regular expressions

Question

0.00/5 (No votes)

See more:

Hi,

I am able to do the same using c# string methods but interested to know is whether we can have any regular expression for solving the same.

C#

String[] result = val.Split('>');
String temp1 = null;
for (int i = 0; i < (result.Length)-1; i++)
{
if(result[i].Contains(" ")&& result[i].Contains("<")&&!result[i].Contains("=") )
{
String[] temp = result[i].Split('<');

temp[1] = temp[1].Replace(" ", "_");
result[i] = temp[0] +"<"+ temp[1];
}
temp1 = temp1 + result[i] + ">";
}

Example

XML

<UnAvailabilityDescriptions t="String[]">
<Index0>Maintenance mode active</Index0>
<Index1>
Remote host connection lost</Index1>
<Index2>
Host NDCLink not available</Index2>
<Index3>
<local unavailability>
</local unavailability>
</Index3>
</UnAvailabilityDescriptions>

to be changed as

XML

<UnAvailabilityDescriptions t="String[]">
<Index0>Maintenance mode active</Index0>
<Index1>
Remote host connection lost</Index1>
<Index2>
Host NDCLink not available</Index2>
<Index3>
<local_unavailability>
</local_unavailability>
</Index3>
</UnAvailabilityDescriptions>

Waiting for help...........
Please do the needful.:-)

Posted 21-May-12 4:14am

phanisowmya

Add a Solution

Comments

VJ Reddy 22-May-12 2:40am

Thank you for accepting the solution :)

2 solutions

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)

VJ Reddy · Accepted Answer · 2012-05-21T05:47:00

The Replace method of Regex class can be used to replace the white space characters with _ as shown below

C#

xmlText = Regex.Replace(
            xmlText, @"(?=<[^=]+?>)(?=</?\w+\s+\w+)(<.*?)(\s+)(.*?>)",@"$1_$3",
            RegexOptions.CultureInvariant | RegexOptions.IgnoreCase);

Where xmlText is the given xml text.

The search pattern
"(?=<[^=]+?>)(?=</?\w+\s+\w+)(<.*?)(\s+)(.*?>)"
searches white space between two words within < and > character where there is no = inside the < and > characters. However, the above replacement works to replace white spaces only at location between words.

i.e. if we have
<local unavailability local unavailability>
it will replace the first space between local and unavailability words.
<local_unavailability local unavailability>
If we ran the above second time with the replaced text then the second space will be replaced.
<local_unavailability_local unavailability>

The above pattern replaces multiple white spaces with a single _ and also it replaces only between words. So, the spaces at the beginning and at end of words remain as it is.

claudiarani · Accepted Answer · 2015-11-02T11:55:00

Hi,

The below solution works out for me. After constructing the XML, I just returned the XML file as string instead of XmlDocument

For Ex:

public static string GenerateXML(string FirstName,string LastName)
{
XmlDocument xDoc = new XmlDocument();

XmlElement root = xDoc.CreateElement("Root");
xDoc.AppendChild(root);

XmlNode xNodeFirstName = xDoc.CreateElement("FirstName");
xNodeFirstName.InnerText = FirstName;
xDoc.DocumentElement.AppendChild(xNodeFirstName);

XmlNode xNodeLastName = xDoc.CreateElement("LastName");
xNodeLastName.InnerText = LastName;
xDoc.DocumentElement.AppendChild(xNodeLastName);

return xDoc.OuterXml.ToString();
}

In the main method

static void Main(string[] args)
{
string strXml=GenerateXML("John","Smith");
XmlDocument doc = new XmlDocument();
doc.LoadXml(strXml);
}

In this way, all the whitespaces and unwanted carriage retrurn were removed.

Removing/Replacing white spaces in Xml Tag stored in a string using regular expressions

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0