fork download
copy 
  1. using System;
  2. using System.Text.RegularExpressions;
  3. public class Test
  4. {
  5.     public static void Main()
  6.     {
  7. 	    string str = @"CREATE SEQUENCE ""MY_SEQUENCE"" MINVALUE -8 MAXVALUE 999 INCREMENT BY 1 START WITH 250  CACHE 50 NOORDER NOCYCLE;
  8. CREATE SEQUENCE ""_SEQUENCE"" MINVALUE 151 MAXVALUE 500 INCREMENT BY 4 START WITH 160  CACHE 30 NOORDER NOCYCLE;
  9. CREATE SEQUENCE ""MY_TEST"" MINVALUE 1 MAXVALUE 888 INCREMENT BY 9 START WITH 1  CACHE 20 NOORDER NOCYCLE;";
  10. 	    var regex = new Regex(@"(.*?MINVALUE )(-)?(?(2)(.*?MAXVALUE ))(\d+)(.*START WITH )(\d+)(.*)");
  11. 	    var result = regex.Replace(str, "$1$2$3$4$5$4$7");
  12. 	    Console.WriteLine(result);
  13.     }
  14. }
Success #stdin #stdout 0.07s 34848KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
CREATE SEQUENCE "MY_SEQUENCE" MINVALUE -8 MAXVALUE 999 INCREMENT BY 1 START WITH 999  CACHE 50 NOORDER NOCYCLE;
CREATE SEQUENCE "_SEQUENCE" MINVALUE 151 MAXVALUE 500 INCREMENT BY 4 START WITH 151  CACHE 30 NOORDER NOCYCLE;
CREATE SEQUENCE "MY_TEST" MINVALUE 1 MAXVALUE 888 INCREMENT BY 9 START WITH 1  CACHE 20 NOORDER NOCYCLE;
https://ideone.com/71MtlS
language:
C# (gmcs 5.20.1)
created:
10 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!