fork download
copy 
  1. using System;
  2. using System.Linq;
  3. using System.Text.RegularExpressions;
  4. public class Test
  5. {
  6. 	public static void Main()
  7. 	{
  8. 		var cols = "select distinct  \n('<a href=ORG_S.htm?keyno='+rtrim(ent.entid)+'  target=_blank id=\"'+rtrim(ent.mdsstring)+'\" name=\"'+rtrim(ent.entid)+'\" class=\"vieworgglobal\">'+rtrim(ent.custno)+' - '+rtrim(ent.company)+'</a>') as customer, ent.phone, 0 as curr,\n\n(select SUM(billmast.balance) as balance from billmast where billmast.billid = ent.entid and ent.cid = 'abis' and billmast.balance<>0 and billmast.invdate>dateadd(day,-60, getdate()) and billmast.invdate<dateadd(day,-30, getdate())\n) as first,\n\n(select SUM(billmast.balance) as balance from billmast where billmast.billid = ent.entid and ent.cid = 'abis' and billmast.balance<>0 and billmast.invdate>dateadd(day,-90, getdate()) and billmast.invdate<dateadd(day,-60, getdate())\n) as second,\n\n(select SUM(billmast.balance) as balance from billmast where billmast.billid = ent.entid and ent.cid = 'abis' and billmast.balance<>0 and billmast.invdate>dateadd(day,-120, getdate()) and billmast.invdate<dateadd(day,-90, getdate())\n) as third,\n\n(select SUM(billmast.balance) as balance from billmast where billmast.billid = ent.entid and ent.cid = 'abis' and billmast.balance<>0 and billmast.adddate<dateadd(day,-120, getdate())\n) as fourth, \n\n(select SUM(billmast.balance) as balance";
  9. 	    var cols1 = Regex.Replace(cols, @"\((?>[^()]|(?<c>)\(|(?<-c>)\))*(?(c)(?!))\)", m => m.Value.Replace(",", ";"));
  10. 	    Console.WriteLine(cols1 == cols);
  11. 	    Console.WriteLine(cols1);
  12. 	}
  13. }
Success #stdin #stdout 0.13s 24464KB
comments ()
stdin
copy 
Standard input is empty
stdout
copy 
False
select distinct  
('<a href=ORG_S.htm?keyno='+rtrim(ent.entid)+'  target=_blank id="'+rtrim(ent.mdsstring)+'" name="'+rtrim(ent.entid)+'" class="vieworgglobal">'+rtrim(ent.custno)+' - '+rtrim(ent.company)+'</a>') as customer, ent.phone, 0 as curr,

(select SUM(billmast.balance) as balance from billmast where billmast.billid = ent.entid and ent.cid = 'abis' and billmast.balance<>0 and billmast.invdate>dateadd(day;-60; getdate()) and billmast.invdate<dateadd(day;-30; getdate())
) as first,

(select SUM(billmast.balance) as balance from billmast where billmast.billid = ent.entid and ent.cid = 'abis' and billmast.balance<>0 and billmast.invdate>dateadd(day;-90; getdate()) and billmast.invdate<dateadd(day;-60; getdate())
) as second,

(select SUM(billmast.balance) as balance from billmast where billmast.billid = ent.entid and ent.cid = 'abis' and billmast.balance<>0 and billmast.invdate>dateadd(day;-120; getdate()) and billmast.invdate<dateadd(day;-90; getdate())
) as third,

(select SUM(billmast.balance) as balance from billmast where billmast.billid = ent.entid and ent.cid = 'abis' and billmast.balance<>0 and billmast.adddate<dateadd(day;-120; getdate())
) as fourth, 

(select SUM(billmast.balance) as balance
https://ideone.com/5IQoN3
language:
C# (gmcs 5.20.1)
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!