Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Parse SQL Insert
//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 == insert.Split(',').ToList()[i].Trim() ) { 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() : "") ); } } } }
run
|
edit
|
history
|
help
0
Task 1_4
radix sort
neja]\
QLSV
Hello World!
Encode URl C#
BNV
hay
HourCouter
Enumerable Range