using System;
using System.Collections;
using System.Collections.Generic;
using System.Text;
using System.Globalization;
using System.Text.RegularExpressions;
namespace Enum
{
class Program
{
static void Main(string[] args)
{
string sql = "INSERT INTO TABLE1(col1, col2, col3, col4, col5) VALUES (,NULL, NULL, NULL, NULL, NULL,)";
string nulls = "NULL";
List<int> indexes = new List<int>();
foreach (Match match in Regex.Matches(sql, nulls))
{
indexes.Add(match.Index);
}
sql = sql.Remove(indexes[2], 4).Insert(indexes[2], "'abc'");
Console.WriteLine(sql);
}
}
}
dXNpbmcgU3lzdGVtOwp1c2luZyBTeXN0ZW0uQ29sbGVjdGlvbnM7CnVzaW5nIFN5c3RlbS5Db2xsZWN0aW9ucy5HZW5lcmljOwp1c2luZyBTeXN0ZW0uVGV4dDsKdXNpbmcgU3lzdGVtLkdsb2JhbGl6YXRpb247CnVzaW5nIFN5c3RlbS5UZXh0LlJlZ3VsYXJFeHByZXNzaW9uczsKCm5hbWVzcGFjZSBFbnVtCnsKICAgIGNsYXNzIFByb2dyYW0KICAgIHsKICAgICAgICBzdGF0aWMgdm9pZCBNYWluKHN0cmluZ1tdIGFyZ3MpCiAgICAgICAgewogICAgICAgICAgICBzdHJpbmcgc3FsID0gIklOU0VSVCBJTlRPIFRBQkxFMShjb2wxLCBjb2wyLCBjb2wzLCBjb2w0LCBjb2w1KSBWQUxVRVMgKCxOVUxMLCBOVUxMLCBOVUxMLCBOVUxMLCBOVUxMLCkiOwoKICAgICAgICAgICAgc3RyaW5nIG51bGxzICA9ICJOVUxMIjsKICAgICAgICAgICAgTGlzdDxpbnQ+IGluZGV4ZXMgPSBuZXcgTGlzdDxpbnQ+KCk7CiAgICAgICAgICAgIGZvcmVhY2ggKE1hdGNoIG1hdGNoIGluIFJlZ2V4Lk1hdGNoZXMoc3FsLCBudWxscykpCiAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgIGluZGV4ZXMuQWRkKG1hdGNoLkluZGV4KTsKICAgICAgICAgICAgfQoKICAgICAgICAgICAgc3FsID0gc3FsLlJlbW92ZShpbmRleGVzWzJdLCA0KS5JbnNlcnQoaW5kZXhlc1syXSwgIidhYmMnIik7CiAgICAgICAgICAgIENvbnNvbGUuV3JpdGVMaW5lKHNxbCk7CiAgICAgICAgfQogICAgfQp9Cg==
INSERT INTO TABLE1(col1, col2, col3, col4, col5) VALUES (,NULL, NULL, 'abc', NULL, NULL,)