fork download
copy 
  1. /* package whatever; // don't place package name! */
  2.  
  3. import java.util.regex.*;
  4. import java.lang.*;
  5. import java.io.*;
  6.  
  7. /* Name of the class has to be "Main" only if the class is public. */
  8. class Ideone
  9. {
  10. 	public static void main (String[] args) throws java.lang.Exception
  11. 	{
  12. 		String example1 = "String query= Select * from table where date between ('2016-05-03' and '2016-05-04' )";
  13. 		String example2 = "SELECT column-names\n FROM table-name1\nWHERE value IN (SELECT date \n               FROM table-name2 \n              WHERE date between ('2016-05-03' and '2016-05-04' ))";
  14. 		String example3 = "String query= Select * from table where date between (\n'2016-05-03' and\n '2016-05-04' )";
  15.  
  16. 		Pattern p = Pattern.compile("between\\s*\\(([^)]*)\\)");
  17. 		Matcher m = p.matcher(example1);
  18. 		System.out.println(m.replaceAll("between $1"));
  19.  
  20. 		m = p.matcher(example2);
  21. 		System.out.println(m.replaceAll("between $1"));
  22.  
  23. 		m = p.matcher(example3);
  24. 		System.out.println(m.replaceAll("between $1"));
  25. 	}
  26. }
Success #stdin #stdout 0.05s 711168KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
String query= Select * from table where date between '2016-05-03' and '2016-05-04' 
SELECT column-names
 FROM table-name1
WHERE value IN (SELECT date 
               FROM table-name2 
              WHERE date between '2016-05-03' and '2016-05-04' )
String query= Select * from table where date between 
'2016-05-03' and
 '2016-05-04'
https://ideone.com/By2mSK
language:
Java (HotSpot 12)
created:
9 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!