fork download
copy 
  1. import java.util.regex.*;
  2.  
  3. class Ideone
  4. {
  5. 	public static void main (String[] args) throws java.lang.Exception
  6. 	{
  7. 		Pattern p = Pattern.compile("(.*?as .*?)(,|$)", Pattern.CASE_INSENSITIVE );
  8. 		String query = "f.id AS id, CONCAT(a1.id, a2.id, a3.id) AS cnp, SUM(A3.nr) AS sum";
  9. 		Matcher m = p.matcher( query );
  10. 		while ( m.find() ){
  11. 			System.out.println( m.group(1) );
  12. 		}
  13. 	}
  14. }
Success #stdin #stdout 0.12s 320576KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
f.id AS id
 CONCAT(a1.id, a2.id, a3.id) AS cnp
 SUM(A3.nr) AS sum
https://ideone.com/f6om5k
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!