Click here to Skip to main content
15,902,112 members

Comments by Member 10266297 (Top 16 by date)

Member 10266297 28-Apr-16 2:11am View    
i am asking if there is a way to pick the string outside the ()
Member 10266297 27-Apr-16 8:42am View    
seem good and smart but i cant change the code behind i have to use the below exactly:

string input = "(Vaue 1) test + test(Vaue 2)bbb * aaa(Vaue 3)";
var matches = Regex.Matches(input, @"(?<=\().+?(?=\))")
.Cast<match>()
.Select(m => m.Value)
.ToList();

foreach (var item in matches)
{
Console.WriteLine(item);
}
Member 10266297 27-Apr-16 8:19am View    
i don't want to use replace because it is fixed in the code and the regex can be entered from a textbox so i need to use replace
Member 10266297 27-Apr-16 7:52am View    
the expected output is: test + test bbb * aaa
everything without ()
Member 10266297 22-Aug-14 4:58am View    
Thank you very much OriginalFGriff it is very helpful

SELECT *
FROM dbo.mytable
INNER JOIN FREETEXTTABLE(dbo.mytable,Name,'search Key') FT
ON mytable.Id = FT.[Key]
ORDER BY RANK DESC