How to insert brackets between text

Question

Hellow I have problem like this. I have SQL query where with button press need to add brackets. Sample of SQL: SELECT something FROM sometable WHERE item1 OR item2 XOR item3 AND item4 Whan I press the botton it's adds brackets that SQL is right. Like this: SELECT something FROM sometable WHERE (((item1 OR item2) XOR item3) AND item4) Please help me.

Frogleg · Answer

I made this up but the length of strings(12) is critical public void addBrkts() { string str = richTextBox1.Text; richTextBox1.Text = (  ); string [] strsp = str.Split( ' ' ); int strLen = strsp.Length ; if (strLen != 12) { return ; } string strAdd = strsp[5].Insert(0 ((( ); strsp[5] = strAdd; string strAdd2 = strsp[7].Insert(strsp[7].Length  ) ); strsp[7] = strAdd2; string strAdd3 = strsp[9].Insert(strsp[9].Length ) ); strsp[9] = strAdd3; string strAdd4 = strsp[11].Insert(strsp[11].Length ) ); strsp[11] = strAdd4; foreach ( string s in strsp) { richTextBox1.AppendText(s); richTextBox1.AppendText(   ); } }

Janis Peksa · Answer

Modify the code xor don't need anymore. public void button1_Click( object sender EventArgs e) { string abc = richTextBox1.Text.Trim(); richTextBox1.Text = abc.Replace(  and   ) and (( ); string abc2 = richTextBox1.Text.Trim(); if (abc2.Contains(  where  ) && (abc2.Contains(  and  ) || abc2.Contains(  or  ))) { richTextBox1.Text = abc2.Replace(  where    where (( ); } int len = richTextBox1.Text.Length; string bca = richTextBox1.Text; string word1 = and ; Regex r = new Regex ( @\b + word1 + @\b  RegexOptions .IgnoreCase); MatchCollection mc = r.Matches(richTextBox1.Text); int mcSum = mc.Count; if (bca.Contains(  where  ) && (bca.Contains(  and  ))) { for ( int i = 0; i { richTextBox1.Text = richTextBox1.Text.Insert(len ) ); } if (mcSum == 1) { richTextBox1.Text = richTextBox1.Text.Insert(len ) ); richTextBox1.Text = richTextBox1.Text.Insert(len ) ); } } }

Janis Peksa · Answer

What didn't work ? I'm not sure that my code is correct.

Frogleg · Answer

Your code above did not work for me - that is why I played with it (the code) So you are OK now ?

Janis Peksa · Answer

I already do it. I just wanna know is my code is correct. For any SQL that have been entered in richtextbox.

Frogleg · Answer

How about this string abc = richTextBox1.Text; richTextBox1.Text = abc.Replace(  WHERE    WHERE ((( ); string abc2 = richTextBox1.Text; richTextBox1.Text = abc2.Replace(  XOR   ) XOR  ); string abc3 = richTextBox1.Text; richTextBox1.Text = abc3.Replace(  AND   ) AND  ); richTextBox1.AppendText( ) );

Janis Peksa · Answer

Yes but still it's now what I need.

Frogleg · Answer

Spaces don't need brackets ? I split the string and added brackets to relevent string

Janis Peksa · Answer

Yes thats was my first clue to do this. But I have SELECT a FROM b WHERE ... etc .... This spaces don't need brackets. So your code is not usefull.

Janis Peksa · Answer

Can someone tell me if this is correct ?

Janis Peksa · Answer

Edited: if (mcSum == 1) { richTextBox1.Text = richTextBox1.Text.Insert(len ) ); richTextBox1.Text = richTextBox1.Text.Insert(len ) ); }

Janis Peksa · Answer

Have make something like this. But don't know if it's works fine: public void button1_Click( object sender EventArgs e) { string abc = richTextBox1.Text.Trim(); richTextBox1.Text = abc.Replace(  and   ) and (( ); string abc2 = richTextBox1.Text.Trim(); if (abc2.Contains(  where  ) && (abc2.Contains(  and  ) || abc2.Contains(  or  ) || abc2.Contains(  xor  ))) { richTextBox1.Text = abc2.Replace(  where    where (( ); } string abc3 = richTextBox1.Text.Trim(); richTextBox1.Text = abc3.Replace(  xor   ) xor (( ); int len = richTextBox1.Text.Length; string bca = richTextBox1.Text; string word1 = and ; string word2 = xor ; Regex r = new Regex ( @\b + word1 + @\b  RegexOptions .IgnoreCase); MatchCollection mc = r.Matches(richTextBox1.Text); Regex r2 = new Regex ( @\b + word2 + @\b  RegexOptions .IgnoreCase); MatchCollection mc2 = r2.Matches(richTextBox1.Text); int mcSum = mc.Count + mc2.Count; if (bca.Contains(  where  ) && (bca.Contains(  and  ) || bca.Contains(  xor  ))) { for ( int i = 0; i { richTextBox1.Text = richTextBox1.Text.Insert(len ) ); } if (mcSum == 1) { richTextBox1.Text = richTextBox1.Text.Insert(len ) ); } } }

Janis Peksa · Answer

Can anyone help please.

Janis Peksa · Answer

Coz I have program witch is showing SQL and you can enter SQL queries. So I need this that my SQL query is right. Thats why I need this brackets to be added.

Janis Peksa · Answer

I'm using richtextbox.

Suthish Nair · Answer

Why you need this kind of functionality?