static void Main(string[] args)
{
//string openFile = @"D:\Studia\MMDS\Next\train.csv";
//string saveToFile = "train.txt";
string openFile = @"D:\Studia\MMDS\Next\test.csv";
string saveToFile = "test.txt";
CSVProcessing.ConvertCSV(openFile, saveToFile);
}
public static void ConvertCSV(string openFile, string saveToFile)
{
int counter = 0;
using (FileStream fs = File.Open(openFile, FileMode.Open))
using (BufferedStream bs = new BufferedStream(fs))
using (StreamReader sr = new StreamReader(bs))
{
string line;
while ((line = sr.ReadLine()) != null)
{
int iterator = 1;
string[] stringSeparators = new string[] { "::::" };
var row = line.Split(stringSeparators, StringSplitOptions.None);
//int clicked = int.Parse(row[1].Trim());
int queryId = int.Parse(row[0].Trim());
string query = row[4];
string link = row[5].Trim();
string[] vertor = row[2].Trim().Substring(1, (row[2].Trim().Length - 2)).Replace(" ", "").Replace(".", "a").Replace(",", ".").Replace("a", ",").Split('.');
var list = new List <decimal>();
//string temp = string.Concat(clicked, " qid:", queryId, " ");
string temp = string.Concat("qid:", queryId, " ");
foreach (var item in vertor)
{
temp = string.Concat(temp, iterator, ":", Decimal.Parse(item, System.Globalization.NumberStyles.Float));
temp = string.Concat(temp, " ");
iterator++;
}
temp = temp.Replace(",", ".");
temp = string.Concat(temp, "# ", query, " | ", link);
CSVProcessing.ExportToFile(temp, saveToFile);
counter++;
}
}
}
