public void LoadCVSData()
        {
            csvData = new List <CsvLine>();
            try
            {
                using (StreamReader reader = new StreamReader(Config.csvFileLocation))
                {
                    string csvLine;

                    while ((csvLine = reader.ReadLine()) != null)
                    {
                        if (csvLine.Trim(' ') != "" && csvLine.Substring(0, 2) != "Id")                 //ignore last line and column headers.
                        {
                            csvLine = csvLine.Replace("Minute,Hour", "Minute--Hour").Replace("\"", ""); //remove quotes and put in a placeholder for tricky comma.
                            string[] csvLineArray = csvLine.Split(',');
                            CsvLine  csvDataItem  = new CsvLine();
                            csvDataItem.Id      = csvLineArray[0];
                            csvDataItem.UtcDate = csvLineArray[1];
                            csvDataItem.Topic   = csvLineArray[2];
                            csvDataItem.Kind    = csvLineArray[3].Replace("Minute--Hour", "Minute,Hour"); //put comma back
                            //csvDataItem.UtcProcessedDate = csvLineArray[4]; //this isn't used in this challenge.

                            csvData.Add(csvDataItem);
                        }
                    }
                }
            }
            catch (Exception e)
            {
                Logging.HandleError("loadCVSData", e);
            }
        }
Exemple #2
0
 private static string CreateJsonString(CsvLine inputLine)
 {
     return(JsonConvert.SerializeObject(inputLine));
 }