View Complete Post
Could you anybody help me, How to replace the remaining String after the Comma Starts Using SQL Query. Below is the data
"MediaRights, MediaRightsLink, MediaRightsCompanies, MediaRightsTypes"
I have some problem with RegEx.
I have text:
"something here [tagQuote=Name of Author]bla bla bla[/tagQuote] something here"
And now I want to replace all the whitespace character in quote attribute with "%#%#%#%".
So I want to have: [tagQuote=Name%#%#%#%of%#%#%#%Author]bla bla bla[/tagQuote]
So remove all of the whitespaces between "[tagQuote=" and "]...[/tagQuote]"
i need to replace a string like change the dataformat, Uppercase,lowercase e.t.c
Ex: I started this question on Sep/29/2010 till i didn't get any REplay.
This has to be change to ...
I Given this question on 29/9/2010 Still i don't got any replay.
How to solve like this type of issue.
Note : this is not my exact requirement, but it matches similar. My String can consists of minimum 500000 words.
Dim strTabString AS string = "A B C "
TextBox1.Text = Regex.Replace(strTabString , "\t", "|")
From the front they are passing some id values
based on those values i want replace my string column
Like .. we have two table
Key ID name
1 2 aaa
1 3 bbb
1 4 xxxx
we are joining these table based on key value
if They are passing like 2 and 3 from the front so i want replace my descrption column with related name values
in this case i need to display my description like cccc,xxxx,ffff...
When I use
select replace(description,a.name,'') from table a join table b
on table a .key = table b.key
and table a.id in (2,3)
when i write like this it displaying 2 records but iwant display in single records
Please give some suggestions to solve this
Thanks in advance
Given a String 'This is a test, this is a second test'
Is there an easy method (preferably without using CLR) to search and replace the string to remove the word 'test' but only if it occurs as the last series of characters in a string?
The end result would be
'This is a test, this is a second'
I have a string like
string str1 = 12345aaaaa~b999~c345678;
I have used str1.Replace("~b999",string.empty);
.contains recognises the substring("~b999") but is not replacing with the empty string as shown.
I have a following string
"<Grid><IO/>\n<Body>\n<B>\n<I id=\"AR1\" Def=\"R\" Panel=\"\" Id=\"1\" Name=\"Activity 1\" Prent=\"\" ResourceName=\"Emp 1\" S=\"11/26/2010 12:00:00 AM\" E=\"12/16/2010 12:00:00 AM\" Predecessor=\"0\"/></B>\n</Body>\n</Grid>"
And i want it in following form
<I id="AR1" Def="R" Panel="" Id="1" Name="Activity 1" Prent="" ResourceName="Emp 1" S="11/26/2010 12:00:00 AM" E="12/16/2010 12:00:00 AM" Predecessor="0"/>
It means i want to replace \ char from upper string. How can i do this. please help.
I am struck very badly. Thanks in advance. please help.
i am looking for a function that takes two string parameters
str1 = "hello how are you today mr john"
str2 = "how today"
and in return it shoud highlight the words "how" and "today".
Any ides? I prefer if its possible using reg expression...Thanks