public static List <SplitingLine> ConvertSqlToTxt(List <string> file)
{
List <string> newText = new List <string>();
List <SplitingLine> newSplitingText = new List <SplitingLine>();
file.RemoveAll(x => Regex.IsMatch(x, "^--") || x == "");
int fileRange = file.Count;
for (int i = 0; i < fileRange; i += 2)
{
string line = file[i].Replace("comment on column ", "").Replace("comment on table ", "");
string comment = file[i + 1].Replace("is '", "").Replace("';", "");
newSplitingText.Add(SplitingLine.SplitLine(line, comment));
}
List <SplitingLine> newSplitingTextWithComments = new List <SplitingLine>();
foreach (var line in newSplitingText)
{
newSplitingTextWithComments.Add(CommentSearch.Find(newSplitingText, line));
}
return(newSplitingTextWithComments);
}
