Blog

How to Replace specific word in given string. [Answered]RSS

12 replies

Last post Jul 26, 2014 06:41 AM by smirnov

‹ Previous Thread|Next Thread ›

Shortcuts

- Reply
swaroopkumar...

Member

5 Points

40 Posts

How to Replace specific word in given string.

Jul 25, 2014 06:57 AM|swaroopkumar1069|LINK

Hi,

I want to replace specific word in below given string. Please look out below small code.

DataTable dtURLs = new DataTable();

DataColumn s1 = new DataColumn("OldURL");

dtURLs.Columns.Add(s1);

DataRow row1 = dtURLs.NewRow();

row1[s1] = "https://www.google.com";

dtURLs.Rows.Add(row1);

DataRow row2 = dtURLs.NewRow();

row2[s1] = "https://www.google.com/services/";

dtURLs.Rows.Add(row2);

string campaignContent =

@"https://www.google.com https://www.google.com/services/";

string queryString = "queryString";

foreach (DataRow dr in dtURLs.Rows)

{

 string pattern = @String.Format(@"\b{0}\b", dr["OldURL"].ToString());

 campaignContent =

Regex.Replace(campaignContent, pattern, dr["OldURL"].ToString() + "?" + queryString);

}

I am trying above the model but I got wrong output like below.

OUTPUT:

https://www.google.com?queryString https://www.google.com?queryString /services/

But I am excepted OUTPUT is like below.

https://www.google.com?queryString https://www.google.com/services/?queryString

Please give any solutions for above issue.

C#.net
- Reply
vinay13mar

Contributor

5745 Points

1901 Posts
Re: How to Replace specific word in given string.

Jul 25, 2014 07:04 AM|vinay13mar|LINK
For replacing specific work from a string you can use Replace function present in .net.

plz check eg;
```
string str="This is really new place.";
string newstr=str.Replace("new","old");
```
in above code we are replacing new word with old present in string

http://msdn.microsoft.com/en-us/library/fk49wtc1(v=vs.110).aspx
C#.net
Thanks
V.K.Singh
- Reply
smirnov

All-Star

35169 Points

9081 Posts

Re: How to Replace specific word in given string.

Jul 25, 2014 07:08 AM|smirnov|LINK

Why not simply to add query string at the end?

//string pattern = @String.Format(@"\b{0}\b", dr["OldURL"].ToString());
//campaignContent = Regex.Replace(campaignContent, pattern, dr["OldURL"].ToString() + "?" + queryString);

campaignContent = dr["OldURL"].ToString() + "?" + queryString;

C#.net
- Reply
swaroopkumar...

Member

5 Points

40 Posts
Re: How to Replace specific word in given string.

Jul 25, 2014 07:15 AM|swaroopkumar1069|LINK
Hi vinay,

i know above replace function. I want specific word for example if your word having 'is' two times right?

I want to replace 'is' word only in your sentence. U got my point.

here output is like below.
```
string newstr=str.Replace("are","is");
```
Result: Thare are really new place.

but i want below result.

This are really new place.
C#.net
- Reply
swaroopkumar...

Member

5 Points

40 Posts

Re: How to Replace specific word in given string.

Jul 25, 2014 07:26 AM|swaroopkumar1069|LINK

HI Smirnov,

Actually my requirement is i have one template, It having lot of Links. I want to add tags(Google analytic tags) to end of each and every link that why i maintain all links in DataTable then looping it and changing one by one. It is fine but in my template having two links like below.

1. http://www.google.com

2. http://www.google.com/service.

I want to change only http://www.google.com to http://www.google.com?queryStirng don't disturb other links.

C#.net
- Reply
smirnov

All-Star

35169 Points

9081 Posts
Re: How to Replace specific word in given string.

Jul 25, 2014 07:28 AM|smirnov|LINK
swaroopkumar1069
```
string newstr=str.Replace("are","is");
```
Result: Thare are really new place.

but i want below result.

This are really new place.
In this case you should use
```
string newstr=str.Replace("Thare","This");
```
C#.net
- Reply
swaroopkumar...

Member

5 Points

40 Posts
Re: How to Replace specific word in given string.

Jul 25, 2014 07:39 AM|swaroopkumar1069|LINK
@vinay & @smirnov

Thanks for reply here the brief explanation of my actual problem.

Actually my requirement is I have one template with lot of links. I get all links in one DataTable. I am looping that DataTable and replace each every link with Google analytics tag which is given by my client.

Here problem is in my template having two links like below.
1. http://www.google.com
2. http://www.google.com/services
I want to replace “ http://www.google.com “ to “ http://www.google.com?ClientTags “ don’t disturb other links. My problem is while replacing 2^nd link also replaced I am getting result like below

http://www.google.com?ClientTags …… something matter …. http://www.google.com?ClientTags/Services

I want to replace only 1^st link only. I want to replace specific word.
C#.net

Re: How to Replace specific word in given string.

Jul 25, 2014 07:54 AM|smirnov|LINK

Why not simply do like this?

string search = "http://www.google.com";
string replace = "http://www.google.com?ClientTags";
int pos = text.IndexOf(search);
if (pos != -1)
   text = text.Substring(0, pos) + replace + text.Substring(pos + search.Length);

Re: How to Replace specific word in given string.

Jul 25, 2014 08:56 AM|swaroopkumar1069|LINK

Thanks for reply. It is working only when text contain one http://www.google.com working fine. But if your template having multiple http://www.google.com links above logic not working. For example like below.

text =@"http://www.google.com <br/> http://www.google.com/services/ <br/> http://www.google.com";

string search = "http://www.google.com";
string replace = "http://www.google.com?ClientTags";
int pos = text.IndexOf(search);
if (pos != -1)
   text = text.Substring(0, pos) + replace + text.Substring(pos + search.Length);

- Reply
smirnov

All-Star

35169 Points

9081 Posts
Re: How to Replace specific word in given string.

Jul 25, 2014 09:52 AM|smirnov|LINK
First of all it is not clear why if you have all urls in the database you put them all in a string and then replace in that string. Instead you can do a loop through all rows and compare urls one by one.

If this is not possible for some reasons then you can try
```
www.google.com(?![/\w])
```
Complete example: https://dotnetfiddle.net/HJxYVQ

Output:
```
http://www.google.com?newstring http://www.google.com/services/ http://www.google.com?newstring
```
C#.net
- Reply
swaroopkumar...

Member

5 Points

40 Posts

Re: How to Replace specific word in given string.

Jul 26, 2014 01:16 AM|swaroopkumar1069|LINK

Thank you very much smirov. Can you please given some reference site address of how to write above patterns.

C#.net
- Reply
swaroopkumar...

Member

5 Points

40 Posts

Re: How to Replace specific word in given string.

Jul 26, 2014 04:50 AM|swaroopkumar1069|LINK

The above solution working fine. IF links having already parameters at that time above code not working. plz check below link.

https://dotnetfiddle.net/h6YsnP

http://www.google.com?newstring?UTM_Source=test This is wrong replacement. If Content links having with parameter and with out parameters.

C#.net
- Reply
smirnov

All-Star

35169 Points

9081 Posts
Re: How to Replace specific word in given string.

Jul 26, 2014 06:41 AM|smirnov|LINK
If http://www.google.com?UTM_Source=test should not be replaced then add ? in [ ]
```
www.google.com(?![?/\w])
```
C#.net

‹ Previous Thread|Next Thread ›