using System;

using System.Text.RegularExpressions;

using System.Linq;

using System.Text;

​

public class Program

{

    public static void Main()

    {

                //DELETE

        //string state="\"COL 1\" = HEXTORAW('4d474d545f5441534b5f51') and \"COL 2\" = HEXTORAW('e749c04e20154c04ac12a521fec96501') and \"COL 3\" IS NULL and \"COL 4\" = HEXTORAW('c202') and \"COL 5\" = HEXTORAW('80') and \"COL 6\" IS NULL and \"COL 7\" IS NULL and \"COL 8\" IS NULL and \"COL 9\" = HEXTORAW('80') and \"COL 10\" = HEXTORAW('80') and \"COL 11\" = HEXTORAW('80') and \"COL 12\" = HEXTORAW('80') and \"COL 13\" = HEXTORAW('787808140e17023178cb80') and \"COL 14\" = HEXTORAW('535953') and \"COL 15\" = HEXTORAW('362e31312e3335303232') and \"COL 16\" IS NULL and \"COL 17\" IS NULL and \"COL 18\" IS NULL and \"COL 19\" = HEXTORAW('80') and \"COL 20\" IS NULL and \"COL 21\" IS NULL and \"COL 22\" = HEXTORAW('80') and \"COL 23\" = HEXTORAW('80') and \"COL 24\" IS NULL and \"COL 25\" IS NULL and \"COL 26\" IS NULL and \"COL 27\" IS NULL and \"COL 28\" = HEXTORAW('00') and \"COL 29\" = HEXTORAW('c108') and \"COL 30\" = HEXTORAW('80') and \"COL 31\" = HEXTORAW('80') and \"COL 32\" = HEXTORAW('787808140e2102') and ROWID = 'AAAQP9AACAAAHfGAAM'";

​

        //string state = "\"COL 40\" = NULL, \"COL 41\" = NULL \"COL 1\" = HEXTORAW('c405165528') and \"COL 2\" = HEXTORAW('c102') and \"COL 3\" = HEXTORAW('c102') and \"COL 4\" IS NULL and \"COL 5\" = HEXTORAW('53434f5454') and \"COL 6\" = HEXTORAW('4e43532d49545c4445562d4f52412d303034') and \"COL 7\" = HEXTORAW('4445562d4f52412d303034') and \"COL 8\" = HEXTORAW('c202') and \"COL 9\" = HEXTORAW('80') and \"COL 10\" IS NULL and \"COL 11\" IS NULL and \"COL 12\" IS NULL and \"COL 13\" IS NULL and \"COL 14\" IS NULL and \"COL 15\" IS NULL and \"COL 16\" IS NULL and \"COL 17\" IS NULL and \"COL 18\" IS NULL and \"COL 19\" IS NULL and \"COL 20\" IS NULL and \"COL 21\" IS NULL and \"COL 22\" IS NULL and \"COL 23\" = HEXTORAW('41757468656e746963617465642062793a2044415441424153453b20436c69656e7420616464726573733a2028414444524553533d2850524f544f434f4c3d7463702928484f53543d3139322e3136382e32302e3132352928504f52543d35333739382929') and \"COL 24\" IS NULL and \"COL 25\" = HEXTORAW('6d6f68616d6d65642e616d696e') and \"COL 26\" IS NULL and \"COL 27\" IS NULL and \"COL 28\" IS NULL and \"COL 29\" = HEXTORAW('c106') and \"COL 30\" IS NULL and \"COL 31\" = HEXTORAW('787808140e0f2703473bc0') and \"COL 32\" IS NULL and \"COL 33\" IS NULL and \"COL 34\" = HEXTORAW('80') and \"COL 35\" = HEXTORAW('323332343a3337343736') and \"COL 36\" = HEXTORAW('0000000000000000') and \"COL 37\" IS NULL and \"COL 38\" IS NULL and \"COL 39\" = HEXTORAW('c50b284a3c43') and ROWID = 'AAAAF/AABAAAxs5AAD'";

        string state = "insert into \"UNKNOWN\".\"OBJ# 383\"(\"COL 1\",\"COL 2\",\"COL 3\",\"COL 4\",\"COL 5\",\"COL 6\",\"COL 7\",\"COL 8\",\"COL 9\",\"COL 10\",\"COL 11\",\"COL 12\",\"COL 13\",\"COL 14\",\"COL 15\",\"COL 16\",\"COL 17\",\"COL 18\",\"COL 19\",\"COL 20\",\"COL 21\",\"COL 22\",\"COL 23\",\"COL 24\",\"COL 25\",\"COL 26\",\"COL 27\",\"COL 28\",\"COL 29\",\"COL 30\",\"COL 31\",\"COL 32\",\"COL 33\",\"COL 34\",\"COL 35\",\"COL 36\",\"COL 37\",\"COL 38\",\"COL 39\",\"COL 40\",\"COL 41\",\"COL 42\") values (HEXTORAW('c40516552a'),HEXTORAW('c103'),HEXTORAW('c102'),NULL,HEXTORAW('53434f5454'),HEXTORAW('4e43532d49545c4445562d4f52412d303034'),HEXTORAW('4445562d4f52412d303034'),HEXTORAW('c20202'),HEXTORAW('80'),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,HEXTORAW('c117'),HEXTORAW('80'),HEXTORAW('c107'),HEXTORAW('80'),HEXTORAW('787808140e103b'),NULL,NULL,HEXTORAW('6d6f68616d6d65642e616d696e'),NULL,NULL,NULL,NULL,HEXTORAW('80'),HEXTORAW('787808140e103b06bc3e40'),NULL,NULL,HEXTORAW('80'),HEXTORAW('323332343a3136373932'),NULL,NULL,NULL,HEXTORAW('c50b284a3c43'),HEXTORAW(''),HEXTORAW(''),NULL);";

        var insertCleanUpPattern = "insert\\sinto\\s.*?\\\".*?\\\".\\\".*?\\\"";

        state = Regex.Replace(state, insertCleanUpPattern, string.Empty);

        var splitStatement =  state.Split(" values ");

        var colHeaders = splitStatement[0];

        var colString = string.Join(

            "],[",

            colHeaders.Split("\",\"")

        );

        colString = colString.Replace("(\"", "([").Replace("\")", "])");

        Console.WriteLine(colString);

        var colValues = splitStatement[1];

        colValues = colValues.TrimStart('(').TrimEnd(';').TrimEnd(')');

        Console.WriteLine(colValues);

        //Console.WriteLine(colHeaders.Replace("(", string.Empty).Replace(")", string.Empty));

        //var regex=new Regex("\\(@\"(?<value>.*?)\",.*?\"(?<value2>.*?)\"");

        var regex=new Regex("\"(?<value>.*?)\"\\s(=|IS)\\s(?<value2>.*?)(,|\\s)"); // DELETE AND UPDATE

        // var regex = (\(\"(?<value>.*?)\))|(\svalues\s(?<value2>.*)) // INSERT

        var colhdrs = string.Join(

                   ",",

                    regex.Matches(state).Cast<Match>().Select(x => "'" + x.Groups["value"].Value + "'")

                   );

        var colvals = string.Join(

                   ",",

                    regex.Matches(state).Cast<Match>().Select(x => {

                        if(x.Groups["value2"].Value.Equals("NULL", System.StringComparison.OrdinalIgnoreCase))

                            return "NULL";

                        if(!x.Groups["value2"].Value.Contains("HEXTORAW")){

                            return x.Groups["value2"].Value;

                        }

                        var val = x.Groups["value2"].Value.Replace("HEXTORAW('", "").Replace("')", "");

                        byte[] data = FromHex(val.ToString());

                        return "'" + Encoding.UTF8.GetString(data) + "'";

                    })

                   );

        var output = colhdrs + "###" + colvals;

        Console.WriteLine(output);

        var temp = string.Join(

                   Environment.NewLine,

                    regex.Matches(state).Cast<Match>().Select(x => x.Groups["value"].Value + "     " + x.Groups["value2"].Value)

                   );

        Console.WriteLine(temp);

        // byte[] data = FromHex("4d474d545f5441534b5f51");

        //string s = Encoding.ASCII.GetString(data);

        //Console.WriteLine(s);

    }

    public static byte[] FromHex(string hex)

    {

        hex = hex.Replace("-", "");

        byte[] raw = new byte[hex.Length / 2];

        for (int i = 0; i < raw.Length; i++)

        {

            raw[i] = Convert.ToByte(hex.Substring(i * 2, 2), 16);

        }

        return raw;

    }

}

​