Parse SQL Insert, C#

Language: Layout:

//Rextester.Program.Main is the entry point for your code. Don't change it.
//Compiler version 4.0.30319.17929 for Microsoft (R) .NET Framework 4.5

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text.RegularExpressions;

namespace Rextester
{
    public class Program
    {
        public static void Main(string[] args)
        {            
            string F55SRTRT = "RTKCOO|char|5~RT55SQDOCO|float|~RTDCTO|char|2~RT55SQLNID|float|~RTTRT|char|3~RT55WODOCO|float|~RTKIT|float|~RTKITL|char|25~RTMMCU|char|12~RTALD|char|4~RTDSC1|char|30~RTLINE|char|12~RTMCU|char|12~RTOPSQ|float|~RTEFFF|numeric|18~RTEFFT|numeric|18~RTBFPF|char|1~RTLAMC|char|1~RTTIMB|char|1~RTOPSR|float|~RTBQTY|float|~RTUOM|char|2~RTRUNM|float|~RTRUNL|float|~RTSETL|float|~RTPWRT|float|~RTSETC|float|~RTMOVD|float|~RTQUED|float|~RTLTPC|float|~RTPOVR|float|~RTNXOP|float|~RTOPYP|float|~RTCPYP|float|~RTAPID|char|12~RTSHNO|char|10~RTOPSC|char|2~RTINPE|char|2~RTJBCD|char|6~RTAN8|float|~RTVEND|float|~RTPOY|char|1~RTCOST|char|3~RTOMCU|char|12~RTOBJ|char|6~RTSUB|char|8~RTRREV|char|3~RTURCD|char|2~RTURAT|float|~RTURDT|numeric|18~RTURRF|char|15~RTURAB|float|~RTUSER|char|10~RTPID|char|10~RTJOBN|char|10~RTUPMJ|numeric|18~RTTDAY|float|~RTWMCU|char|12~RTLOCN|char|20~RTRUC|float|~RTCAPU|char|2~RTACTB|char|10~RTNUMB|float|~RTCBCO|numeric|18~RTCICO|numeric|18~RTIMCO|numeric|18~RTMPRO|float|~RTAPSC|char|1~RTMNSP|float|~RTMXSP|float|~RTCMPE|char|3~RTCMPC|char|10~RTCPLVLFR|float|~RTCPLVLTO|float|~RTCMRQ|char|1~RTANSA|float|~RTANPA|float|~RTANP|float|~RTWSCHF|char|1~RTTRAF|char|1~RTDFOPC|char|1~RTUORG|float|~RT$RUNL4|float|~RT$SETL4|float|~RTRESDESC|char|255~RT$TMAP|float|";
            List<Tuple<string, string, string>> F55SRTRT_List = new List<Tuple<string, string, string>>();
            F55SRTRT.Split('~').ToList().ForEach(val => F55SRTRT_List.Add(new Tuple<string, string, string>(val.Split('|').ToList()[0], val.Split('|').ToList()[1], ((val.Split('|').ToList()[2].Trim().Length > 0) ? val.Split('|').ToList()[2].Trim() : "0")  )));

// F55SRTRT_List.ForEach(v => Console.WriteLine(v.Item1 + " | " + v.Item2 + " | " + v.Item3 ) ); // debug
            
            string insert = "RT55SQDOCO, RT55SQLNID, RTDCTO, RTKCOO, RT55WODOCO, RTMMCU, RTOPSQ, RTTRT, RTKIT, RTKITL, RTBQTY, RTLINE, RTOPSC, RTUORG, RTTIMB, RTRUNL, RT$RUNL4, RTSETL, RT$TMAP, RTSHNO, RTRESDESC, RTMCU, RTJBCD, RTUPMJ, RTTDAY, RTURRF";
            string values = "519963, 1000, 'SQ', '00010', NULL, ' 1001', 1000, 'E', 70284, '70284', 0, '', 0, 2, '2', 720, 720, 10, 100, N'', N'HARD TURN \"\"P\"\" DIA TO SIZE (VERS TOL) *** NOTE - GRD TOL. ***', ' 1001TC', 'TC-201', dbo.DateG2J(GETDATE()), Cast(REPLACE(CONVERT(VARCHAR(8)| GETDATE()| 108)| ':'| '') AS float), '12/19'";
            
            Console.WriteLine(insert.Split(',').ToList().Count());
            Console.WriteLine(values.Split(',').ToList().Count());
            
            Console.WriteLine();
            
            for(int i = 0; i < insert.Split(',').ToList().Count(); i++)
            {
                string val = values.Split(',').ToList()[i].Trim();
                int length = val.Length;
                length = ((val.StartsWith("'")) ? (length - 2) : ((val.StartsWith("N'")) ? (length - 3) : 0));
                
                int tupIndex = -1;
                for(int t = 0; t < F55SRTRT_List.Count(); t++) 
                {        
                    if (F55SRTRT_List[t].Item1.Equals(insert.Split(',').ToList()[i]))        
                    {
                        tupIndex = t;
                        break;
                    }
                }
                
                string fieldFound = (tupIndex >= 0) ? F55SRTRT_List[tupIndex].Item3 : "*";
                
                Console.WriteLine(insert.Split(',').ToList()[i] + " = " + val + " " + ((length > 0) ? "(" + length.ToString() + ")" : "") + " " + fieldFound + " ----- " + ((tupIndex >= 0) ? (length.ToString() == F55SRTRT_List[tupIndex].Item3).ToString() : "") );                  
            }
            
        }
    }
}

Show compiler warnings [ + ] Show input
Compilation time: 0,22 sec, absolute running time: 0,11 sec, cpu time: 0,09 sec, average memory usage: 16 Mb, average nr of threads: 3, absolute service time: 0,35 sec