fork download
copy 
  1.  
  2. import java.util.*;
  3. import java.lang.*;
  4. import java.io.*;
  5.  
  6. class Ideone
  7. {
  8. 	public static void main (String[] args) throws java.lang.Exception
  9. 	{
  10. 		String s = "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' ))";
  11. 		String search="(?s)(between[^(]*)\\((.*)\\)";
  12. 		System.out.println(s.replaceFirst(search, "$1$2"));
  13. 	}
  14. }
Success #stdin #stdout 0.03s 711168KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
SELECT column-names
 FROM table-name1
WHERE value IN (SELECT date 
               FROM table-name2 
              WHERE date between '2016-05-03' and '2016-05-04' )
https://ideone.com/X92G0i
language:
Java (HotSpot 12)
created:
9 years ago
visibility:
secret

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!