fork download
copy 
  1. using System;
  2. using System.Linq;
  3.  
  4. class Program
  5.     {
  6.         static void Main(string[] args)
  7.         {
  8.             string sqlInCol = "ima01 in ";
  9.             //string[] dataList = System.IO.File.ReadAllLines( "../../../DataList.txt");
  10.             string[]  dataList ={
  11.                 "220000004754",
  12.                 "220000004755",
  13.                 "220000004814",
  14.                 "220000004817",
  15.                 "220000004836",
  16.                 "220000004877",
  17.                 "220000004878",
  18.                 "220000004879",
  19.                 "220000004980",
  20.                 "220000004984",
  21.                 "220000004988"
  22.             };
  23.             String[] chunks = dataList
  24.                    .Select((s, i) => new { Value = s, Index = i })
  25.                    .GroupBy(x => x.Index / 2)
  26.                    .Select(grp => ($"( '{string.Join("','", grp.Select(x => x.Value).ToArray())}' )\r\n"))
  27.                    .ToArray();
  28.             string sqlIn = sqlInCol +string.Join($"or {sqlInCol }", chunks);
  29.             Console.WriteLine(sqlIn);
  30.             Console.ReadLine();
  31.         }
  32.  
  33.     }
Success #stdin #stdout 0.03s 17388KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
ima01 in ( '220000004754','220000004755' )
or ima01 in ( '220000004814','220000004817' )
or ima01 in ( '220000004836','220000004877' )
or ima01 in ( '220000004878','220000004879' )
or ima01 in ( '220000004980','220000004984' )
or ima01 in ( '220000004988' )
https://ideone.com/FqUXY9
language:
C# (gmcs 5.20.1)
created:
3 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!