How to insert a value into a string in certain C # positions

Question

I have a program that gets a string from a method. I want to know how to insert a string value into this string in certain positions.

For example:

mystring = "column1 in('a','b')column2 in('c','d')column3 in('e','f')";

Here, how would I insert the string value "and" after each occurrence of the character ")" in mystring?

PS. If possible, also indicate how not to insert it directly at the end.

Answer 1

You can accomplish this with a replacement.

string mystring = "column1 in('a','b')column2 in('c','d')column3 in('e','f')";
mystring = mystring.Replace(")", ") and ").TrimEnd(" and".ToCharArray());

Result:

"column1 in('a','b') and column2 in('c','d') and column3 in('e','f')"

Answer 2

Perhaps the simplest:

mystring = mystring.Replace(")", ") and ");
mystring = mystring.Substring(0, mystring.Length - " and ".Length);

Answer 3

, "" . , , .

, , :

string s = " x in (a, b) y in (c, d) z in (e , f)";

string[] parts = s.Split (')');

StringBuilder result = new StringBuilder ();

foreach( string part in parts )
{
   result.Append (part + ") and ");
}
Console.WriteLine (result.ToString ());

, , ...

, ( where sql) ?

Answer 4

, :

mystring = "column1 in('a','b')column2 in('c','d')column3 in('e','f')"

:

mystring = mystring.Replace(")c", ") and c");

:

mystring = 
    "column1 in('a','b') and column2 in('c','d') and column3 in('e','f')"

, "".

Answer 5

System.Text.RegularExpressions.Regex.Replace(
    mystring, "\\)(?=.+$)", ") and ");

.+$ , . , Regex .

// Do this once somewhere:
System.Text.RegularExpressions.Regex insertAndPattern =
    new System.Text.RegularExpressions.Regex("\\)(?=.+$)");

// And later:
insertAndPattern.Replace(mystring, ") and ");

: , . "\\).+$" "\\)(?=.+$)", .+$ ( ) .